SQL Problems after update to 2.5

[sitewizard]

Hi

We had an installation of 2.0.15 and have just updated it to version 2.5. Most of it has gone ok but when we click on a category we get the following error messge: phpMyFAQ warning [2]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in Mysql.php on line 160

This then loads the rest of the page but the category listing is blank. I have looked at the MySQL tables and the data is still there. For an example of the problem please see http://sitewizard-support.co.uk/category/1/email.html.

What would be causing this and how can we fix it?

Thanks
Robert

[Thorsten]

Hi,

did you run the update script?

bye
Thorsten

[sitewizard]

Hi

Yes, I did. I followed the instructions here: http://www.phpmyfaq.de/documentation.2.5.en.php#3b.

Thanks
Robert

[Thorsten]

Hi,

strange issue. Could you please try to turn on the DEBUG mode in inc/Init.php? Is it possible to get a SQL dump?

bye
Thorsten

[sitewizard]

Hi

I have turned on the debug and Please find the SQL dump here: http://www.sitewizard-support.co.uk/web229-phpmyfaq.sql.

Thanks
Robert

[Thorsten]

Hi,

thanks, I think I've found the issue. I'll work on a fix.

bye
Thorsten

[sitewizard]

Hi

Thank you very much.

Thanks
Robert

[Thorsten]

Hi Robert,

please download the stable snapshot of phpMyFAQ 2.5.x at our download page. Your bug should be fixed now.

bye
Thorsten

[sitewizard]

Hi Thorsten,

Thank you so much. It is all fixed now. Can't tell you how happy that makes me. Thank you.

One other thing, is the admin page meant to look like the attached screen shot?

Thanks
Robert

[Thorsten]

Hi,

please use the admin.css files from the 2.5 template folder. We changed the layout for the backend for better usability.

bye
Thorsten

[sitewizard]

Hi Thorsten,

Thank you very much for all the help. Keep up the great work.

Thanks
Robert

[calvin13]

I had the same problem when i upgraded to 2.5

I tried it with 2.5.x and i had the following error in the upgrader:

DB error: Table 'faqsearches' already exists

Query:

CREATE TABLE faqsearches (
id INTEGER NOT NULL ,
lang VARCHAR(5) NOT NULL ,
searchterm VARCHAR(255) NOT NULL ,
searchdate TIMESTAMP,
PRIMARY KEY (id, lang))

Any idea?

Thanks!

[Thorsten]

Hi,

did you select the correct version in the update script?

bye
Thorsten

[calvin13]

Yes.

When i had the problem updating 2.0.15 to 2.5, i installed again 2.0.15 with a backup (archives and database)

After that i tried to upgrade 2.0.15 with 2.5.x with this option in the upgrader:

Please select your current version:

Phpmyfaq 2.0.2 and later

Thank you for the quick answer

[Thorsten]

Hi,

is it working now?

bye
Thorsten