db upgrade failed, 1.4.8 to 1.5.0

[ardiederich]

I tried upgrading my 1.4.8 install to 1.5.0. On step 5 I get this error:
Error: Table 'faqcategoryrelations' already exists

Query:

CREATE TABLE faqcategoryrelations ( category_id INT(11) NOT NULL, category_lang VARCHAR(5) NOT NULL default '', record_id INT(11) NOT NULL, record_lang VARCHAR(5) NOT NULL default '', PRIMARY KEY (category_id,category_lang,record_id,record_lang) )

I'm using mysql in 1.4 and 1.5. What info can I get you to help troubleshoot?

I had one into one problem earlier in my first attempt with the install because I didn't have enough writable in the inc directory:
Error: The file ../inc/data.php or the directory ../inc is not writeable. Please correct this!

Error: The backup file ../inc/data.php.bak could not be written. Please correct this!

Error: The backup file ../inc/config.php.bak could not be written. Please correct this!

Error: Your version of phpMyFAQ could not updated.

I did "chmod -R a+w inc" to fix that, then continued on with the upgrade. Thanks for the help.

[Thorsten]

Hi,

please take a look at the table faqcategorierelations. Are there any values?

bye
Thorsten

[ardiederich]

Yes, I have 39 rows in there so far. A snippet:

mysql> select * from faqcategoryrelations;
+-------------+---------------+-----------+-------------+
| category_id | category_lang | record_id | record_lang |
+-------------+---------------+-----------+-------------+
| 1 | en | 1 | en |
| 1 | en | 2 | en |
| 1 | en | 4 | en |

[Thorsten]

Hi,

okay, it seems your update went well.

bye
Thorsten