Page 1 of 1

CMSMS Upgrade Issue - ADODB vs. ADODB_LITE, possibly?

Posted: Mon Nov 20, 2006 8:14 pm
by yewang
Hi Guys,

I was trying to upgrade CMSMS from version 0.11 to 0.13. Everything seems to be fine except that the DB Abstraction layer upgrade was failed. I got this error message when I turn the debug switch on in config.php:

Debug:

loading smarty

Debug:

loading adodb_lite

Debug:

loading page functions

Debug:

loading content functions

Debug:

loading pageinfo functions

Debug:

done loading files

Debug:

(mysql): SELECT * FROM cms_userplugins - Error (0):

Debug:

(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs - Error (0):

Debug:

(mysql): SELECT * FROM cms_modules ORDER BY module_name - Error (0):

Debug:

Session found.  Moving on...

Debug:

Session found.  Moving on...

Debug:

(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '7' - Error (0):

Debug:

Session found.  Moving on...

Debug:

Session found.  Moving on...

Debug:

(mysql): SELECT DISTINCT permission_name FROM cms_user_groups ug INNER JOIN cms_group_perms gp ON gp.group_id = ug.group_id INNER JOIN cms_permissions p ON p.permission_id = gp.permission_id WHERE ug.user_id = '7' - Error (0):

Debug:

Session found.  Moving on...

Debug:

(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '7' - Error (0):

Debug:

(mysql): SELECT content_id FROM cms_content WHERE owner_id = 7 - Error (0):

Debug:

(mysql): SELECT content_id FROM cms_additional_users WHERE user_id = '7' - Error (0):

Debug:

(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '7' ORDER BY title - Error (0):

Debug:

(mysql): SELECT * FROM cms_site_versions WHERE sv_id > 0 ORDER BY sv_id - Error (0):


Does anybody know what needs to be done in order for a seamless transition from adodb to adodb_lite? Did I miss some special steps ?
Any suggestions would be greatly helpful!!

Thanks,

-Ye

Re: CMSMS Upgrade Issue - ADODB vs. ADODB_LITE, possibly?

Posted: Wed Nov 22, 2006 1:04 am
by Dee
The debug output seems fine. What makes you think the switch to ADOdb Lite failed? Are things not working? Do you get errors?