[Solved] MYSQL error message after install...?

Hi all,
Sorry if this has been covered, but I searched and could not find my exact issues/questions.
Be prepared for Newbness...

On the manager login page, after upgrading to 1.0, I have two errors listed at the top of the page:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/public_html/manager/includes/user_settings.inc.php on line 17

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/public_html/manager/includes/user_settings.inc.php on line 19

Also, I was wondering about the permissions... I was feeling worried about all the ones I had to set to 0777 for install/upgrade, and I was wondering if/which ones can be changed (and to what) after upgrade/install is complete?

Bonus question: Any way to get rid of the title "My ModX Site" everywhere? Does it change when I get rid of the sample page?


THANK YOU in advance for any help!

Permissions depend on your server’s configuration. They need to be set so that PHP scripts can write to at the very least the assets/cache folder. If you want to be able to use any kind of image upload or insertion feature the assets/images folder will also need to be writable by your scripts (for auto-generated thumbnails and uploads). If your site is using some kind of suexec, then nothing needs to be world-writable. A good way to tell what needs to have writable permissions is to use the File Manager, and see what directories are writable. Windows, of course, has its own way of handling permissions. Others here can help you if that is the case.

Go to Tools -> Configuration and change the Site Name setting to whatever you want. You should carefully look over the entire Configuration; much of it you won’t understand now, but later you’ll be glad to know where to change things.

Thank you very much! I feel dumb for asking that site title one now.

I know I’m not on a Windows server, it’s Linux/Apache and I’ve got cPanel, if that makes any difference.


Edit:
-------
Linux 2.6
Apache 1.3
PHP 5.2
MySQL 5.0


Anyone know anything on the MySQL errors?

Thank you again!

Did you clear your browser cache and cookies? Did you run the installer in upgrade mode (upload the install folder and go to yoursite.com/install)? And clear the site cache, although that probably doesn’t have anything to do with it.

If you were logged in while doing the upgrade it can cause any number of problems from a blank screen to this kind of errors. Also if you had the "stay logged in" box checked, or any other cause for stale cookies. It’s all a mixup between cookies and session files, and can get really ugly.

Thank you for replying again.

I did run the installer in upgrade mode, and I am pretty sure I was not logged in to the Manager before or while installing, and I do not have the "remember me" or "stay logged in" box checked, although Firefox remembers my login info (if that matters). I was logged into cPanel.

I did not clear my browser cache prior to upgrading and I’m not sure how to clear the site cache. Should I have cleared that stuff before upgrading?

I can log in to the Manager fine, and everything seems to work okay so far (I haven’t tried much).

--------------------
Edit:
Okay, I tried to install it again in upgrade mode, and I made sure to do everything right and still get the MySQL errors on the Manager login page.
Anyone?
I also just noticed it still says 0.9.6.3 in the upper right corner of the Manager ...?


Thank you very much, once again, I really appreciate you lending your time and wisdom.

I re-installed 0.9.6.3 in upgrade mode, and it works fine. I’m confused. Tried to upgrade to 1.0 again and I still get those MySQL errors.

...Anyone? I guess I’ll just have to stick with 0.9.6.3 if I can’t figure this out.
:-[

It looks like you’re not getting a clean upload; the version should definitely be changed. Check in the manager/includes/version.inc.php file and see what that says.

Okay, I cleared out all of my modX folders and database and started fresh, and it worked!



Go figure.

Thank you for putting up with me!!