Upgrade and import.sql

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
rboulle
Posts: 7
Joined: Mon May 16, 2005 7:53 am
Location: Toulouse
Contact:

Upgrade and import.sql

Post by rboulle »

Hello,

Thanks a lot for this great program.
1/I upgraded from 1.4.8 to 1.5.2 succesfully but it seems that there is a problem with the stylesheet. It appears with "The five questions posted most recently" and "Top 10". You can have a look at http://rboulle.free.fr/jurisedu/faq/ for an idea of the problem.

2/ I wrote pieces of python scripts to do, from a LaTeX file, the convertions : LaTeX->XML->phpMyFAQ
That way i work straight on my LaTeX file (i can make PDF or PS) and from times to times i can stuff my FAQ. You can dl the scripts here : http://rboulle.free.fr/jurisedu/faq/src/
Please feel free to use them, modify them and send me comments or whatever ! :-)

The matter is that i can't anymore import files even with the one made (phymyfaq-data2005-10-01.sql) made by the system itself. I have the message "it doesn't seem to be a phpmyfaq backup"
Does anyone has got an idea ?
Thanks a lot.
Rémi Boulle.
rboulle AT free DOT fr
Thorsten
Posts: 15728
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Upgrade and import.sql

Post by Thorsten »

Hi,
1/I upgraded from 1.4.8 to 1.5.2 succesfully but it seems that there is a problem with the stylesheet. It appears with "The five questions posted most recently" and "Top 10". You can have a look at http://rboulle.free.fr/jurisedu/faq/ for an idea of the problem.
sure... just look at the generated XHTML code. You have to add something for the both tables in main.tpl.
2/ I wrote pieces of python scripts to do, from a LaTeX file, the convertions : LaTeX->XML->phpMyFAQ
That way i work straight on my LaTeX file (i can make PDF or PS) and from times to times i can stuff my FAQ. You can dl the scripts here : http://rboulle.free.fr/jurisedu/faq/src/
Please feel free to use them, modify them and send me comments or whatever ! :-)
cool... I'll try to port that to PHP. :-)
The matter is that i can't anymore import files even with the one made (phymyfaq-data2005-10-01.sql) made by the system itself. I have the message "it doesn't seem to be a phpmyfaq backup"
Does anyone has got an idea ?
yes, you cannot import 1.4.x backups into 1.5.x because of database changes.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
rboulle
Posts: 7
Joined: Mon May 16, 2005 7:53 am
Location: Toulouse
Contact:

Re: Upgrade and import.sql

Post by rboulle »

Hello,

Thanks for your reply. :)

cool... I'll try to port that to PHP. :-)
Before starting to write those scripts I add to choose a language (I am a total newbie in programming)... In the end, I had to choose between python and PHP. PHP didn't seem to be able to parse xml files. But I don't know a lot of it. Do you think that PHP is more likely to do that kind of treatment easily ?
yes, you cannot import 1.4.x backups into 1.5.x because of database changes.
Yes I know, but the matter is that with 1.5.x, if I make first a backup (backup data) and then want to upload this same file (as a backup file), it doesn't work. I have a message saying that the *.sql file doesn't seem to be a phpmyfaq backup file. :shock: :cry:

It seems to be a problem similar to 1.4.x where we had to change a piece of code in backup.import.sql (or a name like this).

Rémi Boulle.
Thorsten
Posts: 15728
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

I'll take a look at the import routine.

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