Reinstall Failed...

[Sererena]

Recently, my webhost just upgraded to MySQL 5 and all of a sudden my CMS stopped working.  I decided to upgrade to 0.12.1 from 0.11.1 to see if that would solve the problem, but that didn't work. So, I decided to just install 0.12.1 from scratch (without removing the old tables), but after telling me it was installed successfully, I would get a 404 page after going to where my cms site should be.  I reinstalled 4 times, thinking I had made some mistake along the way, but to no avail. 

I was able to access the Admin login page, but it wouldn't let me login.  This is the debug info:

Code: Select all

Debug:
loading smarty
Debug:
loading adodb
Debug:
loading page functions
Debug:
loading content functions
Debug:
loading pageinfo functions
Debug:
done loading files
Debug:
(mysql): SELECT * FROM cms_userplugins - Error (): 
Debug:
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs - Error (): 
Debug:
(mysql): SELECT * FROM cms_modules ORDER BY module_name - Error (): 
Debug:
(mysql): SELECT user_id FROM cms_users WHERE username = 'Admin' AND password = 'xxxxxxxx' AND active = 1 AND admin_access = 1 - Error (): 
Debug:
Got user by username
Debug:
false
Debug:
Login failed.  Error is: Username or password incorrect
Debug:
debug is:Username or password incorrect
Debug:
Debug in the page is: Username or password incorrect

I don't know much about MySQL, but when I looked in the cms_users table, I noticed that it hadn't created the "Admin" account I had specified in the install.  It's like it's not writing into the table. Does anyone have any ideas?  I really like CMSMS, but I have had a lot of trouble when I first installed it, and now I feel like I'm back at square one.

Thanks... any help would be great!  If you need any more info, I'll try to find it!

~Serena

[Russ]

Take a look at your 'config.php' file in the root of your install, make it writable (if it isn't already - and then re-set to readonly when finished,) then take a look at your database and password and user ID settings. Also check with you ISP database admin product, if the table is still there? or has moved ?or has it's name or access changed?

Has the ISP changed anything else, like paths?

Hope this helps

Russ