Created Joodatabase Catalog pointing to existing database. Picked the fields with special functions from the dropdown list so there are no typos. Created the catalog show on attachement Catalog View.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/l/a/d/laddwebnet/html/joomla/libraries/joomla/database/database/mysql.php on line 344
I get this warning twice. I can only see the firt 100 records in the list view. If I select ALL from the show number of records box I get the message: No Data - The Result was Empty.
Any ideas? Is there something wrong with my database? I attached a snapshot of part of the database in the file Database Snapshot.
I set the demo data base up and it didn't show the same problem.
I've spend alot of time on this and I'm close to defeat. Any help is appreciated.
PS: I did reinstall Joodatabase and clear the tables to make sure that the install was fresh and had the same results.
Thanks.