Impost from 2.0.9 to 2.8.23

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
aznetcowboy
Posts: 3
Joined: Fri Jun 26, 2015 11:18 pm

Impost from 2.0.9 to 2.8.23

Post by aznetcowboy »

I strongly suspect there is no way to do the importing of my FAQ data from version 2.0.9 to 2.8.23, but I thought I should ask first. Re-adding all the FAQ dat will be a really time consuming task otherwise. :oops:
Thorsten
Posts: 15749
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Impost from 2.0.9 to 2.8.23

Post by Thorsten »

Hi,

I would do the following:

- upgrade your 2.0.9 version to 2.5.9
- then upgrade in a second step to 2.8.23

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
aznetcowboy
Posts: 3
Joined: Fri Jun 26, 2015 11:18 pm

Re: Impost from 2.0.9 to 2.8.23

Post by aznetcowboy »

I couldn't find 2.5.9, so I took the highest file and downloaded it which was 2.5.7. While trying to update it, I am getting an error dialog box telling me the following:

DB error: Table 'faq_faqsearches' already exists

Query:

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


I deleted the file from the database, but that did not help either. What is this trying to tell me?
aznetcowboy
Posts: 3
Joined: Fri Jun 26, 2015 11:18 pm

Re: Impost from 2.0.9 to 2.8.23

Post by aznetcowboy »

First of all, a correction to my 1st posting. I had a folder, the only only with phpMyFAQ, and it was titled phpmyfaq_2-0-9. So of course I assumed that was what I had installed. After all, I have been using phpMyFAQ for years now. Then I just happen to notice some print on the lower left hand corner of the screen that I couldn't quite make out, so I highlighted it. It said the version I had installed was 2.6.11. Big oops here on my part. :oops:

So after doing a restore of the mysql database and the phpMyFAQ folder and making sure it was working okay, I then tried running the 2.8.23 version to do an upgrade. It would not work for me. It kept messing up the database. I finally gave up and did a complete install of version 2.8.23 into a different folder and into a different mysql database. So at the moment I am running the 2.6.11 version on my website while I am moving over the FAQ's one at a time over to the version 2.8.23 installation. Luckily there are "only" about 170 of them. The next thing will be trying to get the same look as I had before.

I apologize for for not noticing my version error sooner. :oops:
Thorsten
Posts: 15749
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Impost from 2.0.9 to 2.8.23

Post by Thorsten »

Hi,

no problem. But it would be possible to upgrade from your 2.6.11 version to 2.8.23 with no big hazzle!

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