Line 344 and Cannot Add Category Errors

[waxgod]

Hello!

Ok, here's the problem:

After not trying to add any pictures or categories for a month or two, we're not getting both of these errors in the backend of Joomla:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.*******/****/*****.com/libraries/joomla/database/database/mysql.php on line 344

And,

Error Saving Phoca Gallery Categories

We have not updated Phoca Gallery recently however we have updated Joomla to 1.5.15 (most recently). After searching extensively on here and google, we have yet to find a clear solution. All tables seem to be in order and the front end works fine.

We're not really very good with MySql but can follow instructions. Please, can anyone help us work through this problem?

Thanks

[reko]

which version of phoca gallery are you using?

[juntima]

Thanks for the reply it is 2.5.8

[waxgod]

The DB




phocagallery table



categories table



comments

[reko]

hi,
are you, waxgod and juntima, talking about the same site?

judging from the images, it looks like you're missing 2 columns in your db-tables...
see https://www.phoca.cz/documents/2-phoca-g ... ca-gallery for more information (the bottom part)

/rk

[juntima]

Thanks again for the reply we are talking about the same site.

[juntima]

Hi is there any chance of a step by step tutorial to resolve this problem any help would be appreciated.

[reko]

i think you have to follow these steps (from the link i postet above):

If you have all tables in your database (e.g. you are upgrading from 2.1.0 to 2.2.0) check the columns of your tables. E.g. in Phoca Gallery version 2.2.0 there are new colums: extlink1, extlink2 and these should be added into table: #__phocagallery. In case you are upgrading e.g. from 2.1.0 to 2.2.0 and you got some error message while automatically upgrading of Phoca Gallery tables, check the #_phocagallery table and if extlink1 or extlink2 columns are missed, then run the SQL query for 2.2.0 version:

ALTER TABLE `#__phocagallery` ADD `extlink1` text NOT NULL AFTER `params` ;
ALTER TABLE `#__phocagallery` ADD `extlink2` text NOT NULL AFTER `extlink1` ;

If you're upgrading to 2.2.2 then run also the SQL query for the 2.2.2 version:

ALTER TABLE `#__phocagallery_categories` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `description` ;

change # to the table-prefix you're using (most likely §_jos) an run the commands from in database management (eg. phpmyadmin)
but as always make a backup before you do anything!

[waxgod]

First off, thank you for your time and replies!

We've figured out how to run SQL queries and successfully altered both phocagallery and phocagallery_categories. There were no errors after running the queries. But it not fix our problem!!

We're still getting the same Line 344 on the "Images" page in the back-end and cannot add new categories either.

Here are the new screens:






Please help.

[reko]

I once had a similar problem, see this thread: viewtopic.php?f=1&t=3737&start=10#p18217

if that doesn't help, i don't know any further...