Warnings

[aleph]

Hi,
I've two warnings when trying the install 1.5 for the first time :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /.../includes/functions.php on line 334
(...and the same on line 381),

tried and re-tried, replaced (as seen in the forum !)
$query = "SHOW TABLES FROM `".$pixelpost_db_pixelpost."' LIKE `".$pixelpost_db_prefix."addons'";
by
$query = "SHOW TABLES FROM `".$pixelpost_db_pixelpost."` LIKE '".$pixelpost_db_prefix."addons'";

..."show table" works (MySQL 5.0.) and the file exists.

Any suggestion...?

[GeoS]

Oryginal query is ok. There is some problem with your MySQL server. Try to execute:
SHOW TABLES FROM `you_db_name` LIKE 'prefix_addons';
If it doesnt work that means for sure you have problem with your MySQL server.

PS Youve made mistake in oryginal query - youve mixed ' and ` marks in it (its order).

[aleph]

Thanks for your answer,
you' re absolutely right, the original query is correct (guess I went wrong somewhere...) but as I said above - maybe unproperly - I can execute "Show tables" on the server without problem, and still have those warnings... :(

[aleph]

by the way... here are more informations :
PHP-version 4.4.3
MySQL version 5.0.25
... seems there 's nothing to worry about !

You've done a great job with Pixelpost anyway, too bad I can't use it !

[GeoS]

This query should be valid with MySQL 5.x as manual shows same syntax:
http://dev.mysql.com/doc/refman/5.0/en/show-tables.html

Please try execute this query i.e. in phpMyAdmin:
SHOW TABLES FROM `you_db_name` LIKE 'prefix_addons';

[aleph]

No problem to execute the query in phpMyAdmin, but I think you gave me the answer, the link says :
"Note: If you have no privileges for a table, the table does not show up in the output from SHOW TABLES or mysqlshow db_name."
... and I had the "sessions" problem (had to create "sessions" dir located at the same place than the PP dir)
The table exists anyway... turned the test into comment -sincere apology-... and seems to work fine like this...
Thanks

[GeoS]

Cool that it works fine right now :)