[solved] mysql error

3 Posts

andre_l Reply #1, 20 years, 8 months ago

Hi,

i got a little problem with my modx installation.

here are the error messages after running the installation...

Setup will now attempt to setup the database:

Creating connection to the database: OK!

Selecting database `122_andreleubner`: OK!

Creating database tables: OK!

Writing configuration file: OK!

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 78

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 81

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 93

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 111

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 121

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 133

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 149

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 169
Couldn't determine next publish event!
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 215
Couldn't determine next unpublish event!
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/andre-leubner.de/htdocs/manager/processors/cache_sync.class.processor.php on line 225

Installation was successful!

what is the problem? as i installed it the same way on an other server there was no error...

if i try to log in into the backend it says "incorrect username or password entered" but username and password is ok.

pls help me wink

andré

Web Server:
----------------
PHP version ?
MySQL 4.0.25
Operating System and version?

Browser/Client:
-----------------
Firefox 1.5.0
Win XP Prof

MODX Staff
10,725 Posts

opengeek Reply #2, 20 years, 8 months ago

It looks like the tables never got created, though the installer should have warned you of the issue. Can you see if the tables exist via phpMyAdmin. If so, I suggest removing them and trying again, if this was a new installation and not an upgrade.

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

3 Posts

andre_l Reply #3, 20 years, 8 months ago

Can you see if the tables exist via phpMyAdmin.

Which table do you mean? Where can i see this im phpMyAdmin?

MODX Staff
10,725 Posts

opengeek Reply #4, 20 years, 8 months ago

I’m refering to all of the modx tables (would be prefixed with whatever you specified as the table prefix when describing your database connection properties). I’m suggesting you DROP the tables and/or the database itself, and start from scratch and see if you notice any other error messages. It’s strange that it would say the tables were created successfully and then die on the initial step of preparing the site cache for first use. And I just need more information to determine why it is not working. Have you installed other php/mysql applications successfully in your environment?

phpMyAdmin is a web-based DB administration interface for MySQL, that is commonly deployed in LAMP environments. If you setup PHP/MySQL yourself on your XP box, you’d need to install this yourself. If, on the other hand, you use a package like XAMPP, it is included by default so you can instantly get access to it.

For more information on XAMPP, see http://www.apachefriends.org/en/xampp.html
For more information on phpMyAdmin, see http://www.phpmyadmin.net/home_page/index.php

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

3 Posts

andre_l Reply #5, 20 years, 8 months ago

oh it was such a stupid error...
the table prefix was false, now with prefix modx_ it´s no problem... grin

MODX Staff
10,725 Posts

opengeek Reply #6, 20 years, 8 months ago

Quote from: andre_l at Feb 13, 2006, 01:45 PM

the table prefix was false, now with prefix modx_ it´s no problem...

Glad you got it worked out and let us know if you have any other questions or issues using MODx.

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek