HELP! My site is down and I don't know what to do!

sporto · Post by **sporto** » Wed 3. May 2006, 04:51

I've been using PHPWcms with no problem for a site, http://www.animalsense.com/index.php. Today out of nowhere it is now coming up with errors.

Code: Select all

Parse error: syntax error, unexpected T_PUBLIC, expecting T_STRING in /home/animalse/public_html/include/inc_lib/general.inc.php on line 281

Please help! I am at a loss!

DeXXus · Post by **DeXXus** » Wed 3. May 2006, 06:12

Same problem before with no description or followup:
http://www.phpwcms.de/forum/viewtopic.php?t=8938

You know you didn't change phpWCMS, so your web hosting made a change... upgraded PHP / MySQL -or- changed some system / account settings, etc.

sporto · Post by **sporto** » Wed 3. May 2006, 14:11

I am at a compte loss. The web host says that there have been no changes to the server at all.

sporto · Post by **sporto** » Wed 3. May 2006, 14:13

I have the database backed up (I was using PHPWcms rc4). If I do a complete reinstall, can i reinstall the existing database? And what about the templates that I'm using. I'm so frustrated.

sporto · Post by **sporto** » Wed 3. May 2006, 14:46

So, all other scripts (phpbb, listmessenger) are still working on my server, but phpwcms is dead. I need to recover the data from the site.

I have the database dump, but the data all seems to be encripted. How to I extract the content from the database? Do I need to do a fresh reinstall? Thoughts?

ff123 · Post by **ff123** » Wed 3. May 2006, 14:48

In the mentioned article this was said:

Think there is a Article with a 'defect' Content.

That could be a problem.
You could redirect your index page to another category with different content parts.

You could download the site/db to localhost and check it on you own PC/localhost. This way you could be able to find out if the hoster is the problem. Downloading a database is very easy with mysqlfront for example.

Check phpinfo.php to see if things changed on the server.

This website seems to have the same problem (also phpwcms):
http://www.footjucken.org/
Could not whois them, but google gave this:
Impressum. Bolleke Kneipe - Biergarten - Events Obermeidericher Str. 2 47138 Duisburg Tel: 0203-4176484 Inhaber: Ralf Siedek

sporto · Post by **sporto** » Wed 3. May 2006, 15:40

Thanks. I checked different content parts and all have the same issue. I downloaded the DB but the content is encripted. If someone wants to look at it, I'll be happy to post it, but I don't know how to review the DB for defects. I did run a clean up command through phpmysql but that didn't help.

ff123 · Post by **ff123** » Wed 3. May 2006, 16:40

Did you backup your db on a regular basis?
Perhaps than you can restore a backup.

What do you mean with encrypted?

sporto · Post by **sporto** » Wed 3. May 2006, 16:55

What do you mean with encrypted?

I was hoping that I'd be able to view the html code stored in the database, but when I open the backed up SQL database, the article content tables look like this (edited as to not take up pages of characters):

Code: Select all

INSERT INTO `phpwcms_articlecontent` VALUES (1, 2, 4, '20060412123324', '', 0x3c7020616c69676e3d2263656e746572223e4e65772053747564656e74204f7269656
e746174696f6e2077696c6c2062652068656c64206f6e2054756568696361676f6c616e6
4202d20636f6d65206f757420616e642073656520666f7220796f757273656c66213c627
2202f3e3c6272202f3e3c2f666f6e743e3c2f6469763e3c6272202f3e3c7461626c652063
656c6c73706163696e673d2230222063656c6c7061646469, '', 0, '', '', '', 0, '')

My though of a database restore is to do a completely new fresh install and then restore the database. Should I do a fresh install of the RC4 which I'm currently using? I think I"m grasping at straws here. THanks for all your assistance.

ff123 · Post by **ff123** » Wed 3. May 2006, 17:20

If you have a backup of the db, you can restore it in an new database.
Like: your current database is "phpwcms".
Then you restore your backup into a new database "phpwcms2".

Then you have to edit conf.inc.php and mention the new database here:
Like this:
// database values
$phpwcms["db_host"] = "localhost";
$phpwcms["db_user"] = "root";
$phpwcms["db_pass"] = "";
$phpwcms["db_table"] = "NEW DATABASE COMES HERE";
$phpwcms["db_prepend"] = "";
$phpwcms["db_pers"] = 1;

I still cannot understand why your content is encrypted. When I look into
`phpwcms_articlecontent` -> acontent-text, I see clear content, like:
"bestuurbestuur bestuurbestuur bestuurbestuur bestuurbestuur bestuurbestuur bestuurbestuur".
I am using mysqlfront to look into db, fyi.

But even when content is encrypted, you still can download the database and test it on localhost, not?