SQL Problems after update to 2.5

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

calvin13
Posts: 10
Joined: Sun May 27, 2007 6:38 pm
Contact:

Re: SQL Problems after update to 2.5

Post by calvin13 »

It is working but with 2.0.15

I tried two times with no good results... (2.0.15 to 2.5.x)

I will try this: 2.0.15 update to 2.5 and after update to 2.5.x

any idea?

Thanks!
Thorsten
Posts: 15725
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: SQL Problems after update to 2.5

Post by Thorsten »

Hi,

just update from 2.0.15 to the stable snapshot at once with the option "updating from 2.0.2 and later".

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
calvin13
Posts: 10
Joined: Sun May 27, 2007 6:38 pm
Contact:

Re: SQL Problems after update to 2.5

Post by calvin13 »

Hi, I have tried this again (2.0.15 to 2.5.x), and i have the same error:

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))

Thanks!
Thorsten
Posts: 15725
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: SQL Problems after update to 2.5

Post by Thorsten »

Hi,

your database is already updated to 2.5.... this is the issue.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply