another phpMyFAQ instance?

riacheslav · Post by **riacheslav** » Wed May 28, 2008 8:47 pm

Hi,

I'm trying to install a new version of phpMyFAQ. I want to leave the old instance running, I just need to put a new one up. Yet every time I try to run the install on the new one I first get a mysql connect error.

"Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/serve/adbrite/new_help/inc/PMF_DB/Mysql.php on line 67"

Yet no error message is given by my mysql db. I've checked user/pass/etc, many times now- and I do have another instance of phpMyFAQ running, so I'm fairly sure those settings are accurate...

As I say, there is an old instance running- the install page has the message: "Do not use it if you're already running a version of phpMyFAQ!" at the bottom. Is this part of my problem?

any help is much appreciated,
Richard Grove

Post by **Thorsten** » Thu May 29, 2008 6:33 am

Hi,

you have to do a clean install in a second directory. Then another installation is no problem.

bye
Thorsten

riacheslav · Post by **riacheslav** » Thu May 29, 2008 5:34 pm

Hi,

Thanks for your reply.

I do have a clean install happening, I think, in a new directory.

I got a message from my host who said:

"Something in the software needs to be configured to not use a local socket (/var/lib/mysql/mysql.sock) for communication with the webserver and actually use a tcp/ip socket to mysql.serve.com on port 3306."

Is that correct?

R

riacheslav · Post by **riacheslav** » Thu May 29, 2008 11:30 pm

How about this: I've got an old version of phpMyFAQ (2.0.4) running, and I want to have a new version (2.0.7) on a new server. Can I simply install a clean new version of 2.0.7 and then import the data from the old version? The only way I can think of to do this is pretty onerous-- I'm hoping there is something simple...

Post by **Thorsten** » Fri May 30, 2008 6:39 am

Hi,

riacheslav wrote:How about this: I've got an old version of phpMyFAQ (2.0.4) running, and I want to have a new version (2.0.7) on a new server. Can I simply install a clean new version of 2.0.7 and then import the data from the old version? The only way I can think of to do this is pretty onerous-- I'm hoping there is something simple...

yes, you can do this!

bye
Thorsten

riacheslav · Post by **riacheslav** » Fri May 30, 2008 5:27 pm

How? I can't find anything resembling this in the documentation or in the admin interface. It seems like the schema has changed quite a bit from 2.04 to 2.07-- is there a way to port the data to the new interface or am I stuck installing 2.04 then importing, then upgrading?

Also, can you tell me about the socket question above?

riacheslav · Post by **riacheslav** » Fri May 30, 2008 9:52 pm

How? I can't find anything resembling this in the documentation or in the admin interface.

To test all this, I installed a fresh 2.0.4 on my new host, then imported my old data into the db. i had to change data.php- changed the prefix for the database to look at my old data. all good so far, worked no problem. then i got the new software, 2.0.7, copied all the files except /template and inc/data.php, as it said in the documentation. ran the update and now can't log in. the data seems to come over fine, but not the users. schema looks different too...

Also, can you tell me about the socket question above?

Post by **Thorsten** » Sat May 31, 2008 10:46 am

Hi,

do a new, clean install of phpMyFAQ 2.0.7 on your new server. Then export all data from the 2.0.4 install in admin backend. Then restore the backup on the new system. Please run the update script after that.

bye
Thorsten

Post by **Thorsten** » Sat May 31, 2008 10:47 am

Hi,

riacheslav wrote:"Something in the software needs to be configured to not use a local socket (/var/lib/mysql/mysql.sock) for communication with the webserver and actually use a tcp/ip socket to mysql.serve.com on port 3306."

phpMyFAQ doesn't support other sockets as the default one. We'll do this in a future release.

bye
Thorsten