Installation issue - CPanel interface

[MichelleRoberts]

Hi

I've been trying to update a very old version of phpMyFAQ that was installed through CPanel. I think it was 1.1. I have deleted the directory and everything else entirely as it couldn't be updated, and then uploaded the new 1.6.3 version. I would really like some help - because there's nothing I can find that I've done wrong - and I don't know where to begin. If you can help, please explain it very simply, and don't assume I know much (because I don't). I can get part of it working, but have these error messages on the page:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php on line 324

Warning: Cannot modify header information - headers already sent by (output started at /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php:324) in /home/matisse/public_html/phpmyfaq-1.6.3/index.php on line 90

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php on line 162

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php on line 144

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php on line 144

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php on line 144

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php on line 176

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php on line 176

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php on line 144

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpmyfaq-1.6.3/inc/mysql.php on line 144

Michelle

[david_de]

Did you check the documentatin.en.html? It is in the Docs folder. See if you missed any steps on the update section.

Can you restore yours to where it was to make sure of the version number? There is an update script you have to run after you overwrite the old files with new ones. It wants to know what version you are updating from.

I would backup my database too. There may be a way to do a new install then restore the data. Thorsten will be on later and give you better information I think. Until then read the document and try to find out what version you had. If you have any of the php files maybe you can find the version in the comments.

[Thorsten]

Hi,

from which version did you try the update? Please read the dodumentation how the update works because you've deleted inc/config.php and inc/data.php which broke the update stages.

bye
Thorsten

[MichelleRoberts]

I had deleted the FAQ scripts from the server, so had to reupload them to find the version.

It is 1.3.11a

I had orginally thought it to be an earlier version, and thought I could do a complete reinstall. However, after uploading this, I am currently trying to follow the steps in the documentation for upgrading from 1.3.

I did try this, and it doesn't seem to have worked, but before I ask for help again, I'll delete the new version from the server and upload an clean version to see if that makes a difference.

I'm wondering though, if the issue has something to do with the first version being installed through CPanel. I have found that I can't use 'localhost' with other php scripts, and have to put an IP address in. There is also issues with prefixes.

I will report back with my next attempt.

[MichelleRoberts]

OK... I've got a really stupid question to ask.

I'm going through the process of updating. I have a folder on my current website called /phpMyFAQ/ where I have left the required files.

When I copy the NEW files to the website - do I copy them to THIS folder OR create a new directory for them.

Yes, I know, it's silly - but please humour me...

[david_de]

Yes you copy the new files over the old ones then run the update script. Only the files it says to copy. As Thorsten said you keep the old data and config php from the inc folder. Often some or all of the template files also depending on your version and what the document says to do.

[MichelleRoberts]

I followed the bouncing ball in the documentation for upgrading from 1.3.x.

I had a back of my old php scripts, so I recreated that folder, and deleted everything that I was told to delete.

I then copied the new files over the top being careful not to copy over the folders I was told to keep.

Did the update bit, and came up with a new set of errors... HELP!!!

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpMyFAQ/inc/mysql.php on line 176

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpMyFAQ/inc/mysql.php on line 176

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpMyFAQ/inc/mysql.php on line 176

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpMyFAQ/inc/mysql.php on line 176

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpMyFAQ/inc/mysql.php on line 144

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpMyFAQ/inc/mysql.php on line 144

| | | |

Error: Table 'matisse_faq1.faqdata' doesn't exist
Query:

INSERT INTO tempfaqdata SELECT faqdata.id AS id, faqdata.lang AS lang, faqdata.active AS active, faqrubrik.id AS rubrik, faqdata.keywords AS keywords, faqdata.thema AS thema, faqdata.content AS content, faqdata.author AS author, faqdata.email AS email, faqdata.comment as comment, faqdata.datum AS datum FROM faqdata INNER JOIN faqrubrik ON faqdata.rubrik = faqrubrik.rubrik

[Thorsten]

Hi,

why is your table faqdata missing? Something is extremely wrong with your installation.

bye
Thorsten

[MichelleRoberts]

Yes, it hasn't been going too well

I think with all I had done trying to make it all work, somewhere along the lines the database was affected. I had a backup, so I reimported all the data, and then redid the whole update of FAQ again.

Got it working to some point now. However, the following message came up at the end. The main page of the database seems to show up everything except the categories, and I tried to run the bbcode fix script, but got a similar error message.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpMyFAQ/inc/mysql.php on line 176

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/matisse/public_html/phpMyFAQ/inc/mysql.php on line 176

| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

The database was updated successfully.

phpMyFAQ

Please remove the backup (*.php.bak and *.bak.php) files located in the directory inc/.

This file was deleted automatically.

Please delete the file 'installer.php' manually.

[Thorsten]

Hi,

can you please send me an e-mail so we can fix your problems.

bye
Thorsten