Reinstall Failed...
Posted: Thu Apr 27, 2006 6:29 am
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:
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
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
Thanks... any help would be great! If you need any more info, I'll try to find it!
~Serena