TalkPHP
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
» Vulnerable methods and the areas they are commonly trusted in.
» Simple way to protect a form from bot
» The Basics On: How Session Stealing Works
» How to keep your forms from double posting data
IRC Channel
IRC Speech Bubble Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.
Associates
Associates
CSS Tutorials
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 06-21-2010, 11:26 AM   #1 (permalink)
The Visitor
 
Join Date: Jun 2010
Posts: 2
Thanks: 1
haylau is on a distinguished road
Default Corrupt database

Help

I am very new to MySql. I have inherited a website. The previous webmaster used a MySql database for news items.

I took a back up of the whole site using FTP, then restored simply by FTP the files back up, but the database now seems corrupt

I have attached a word doc to show the errors I get. it seems as thought the database has duplicated itself

The coding on the web pages has NOT been modified

Desperately need some help here
Attached Files
File Type: doc mysql errors.doc (622.5 KB, 162 views)
haylau is offline  
Reply With Quote
Old 06-21-2010, 05:07 PM   #2 (permalink)
Wizard
Top Contributor 
 
Village Idiot's Avatar
 
Join Date: Sep 2007
Posts: 1,299
Thanks: 17
Village Idiot is on a distinguished road
Default

I have some good news for you, your database is not corrupt. Both errors you are seeing are PHP functions that are being re-declared. This means that there are two of the same scripts being included. Download the site to a separate directory (for reading purposes only) then use a text search program (such at notepad++'s search feature or Agent Ransack) and scan for those function names. That will find you your duplicates and hopefully will give a pattern so you can see how this happened.
__________________

Village Idiot is offline  
Reply With Quote
Old 06-21-2010, 05:25 PM   #3 (permalink)
is cute and cuddly
 
delayedinsanity's Avatar
 
Join Date: Mar 2008
Location: Vegas, Baby
Posts: 963
Thanks: 31
delayedinsanity is on a distinguished road
Default

I think we need to back up a step here and forget about the errors being displayed in favor of focusing on the issue that has been presented: The corrupt database.

How corrupt has it gotten? Coffee scandal corrupt, or are we talking major government cover up corrupt?

These are things we need to know man.
delayedinsanity is offline  
Reply With Quote
Old 06-22-2010, 06:48 PM   #4 (permalink)
The Visitor
 
Join Date: Jun 2010
Posts: 2
Thanks: 1
haylau is on a distinguished road
Default

Hi, not a major corrupt just a few News items for a manufacturing company

So no "News of the Word" expose

I have sorted the problem, omehow during the download and subsequent upload many of the php files duplicated themselves internally. By that I mean that the code inside each file was listed twice. Very baffling. Anyway I have deleted the extra cosing and all is (nearly) well
haylau is offline  
Reply With Quote
Old 06-22-2010, 07:07 PM   #5 (permalink)
is cute and cuddly
 
delayedinsanity's Avatar
 
Join Date: Mar 2008
Location: Vegas, Baby
Posts: 963
Thanks: 31
delayedinsanity is on a distinguished road
Default

Good to know you got it sorted; just remember, don't be surprised if Michael Moore shows up to create a half assed documentary about your experience with corrupt databases.
delayedinsanity is offline  
Reply With Quote
The Following 2 Users Say Thank You to delayedinsanity For This Useful Post:
haylau (06-22-2010), nefus (06-23-2010)
Old 06-23-2010, 12:56 PM   #6 (permalink)
The Contributor
 
nefus's Avatar
 
Join Date: Nov 2007
Location: Nashville, TN
Posts: 66
Thanks: 20
nefus is on a distinguished road
Default

Quote:
Originally Posted by delayedinsanity View Post
Good to know you got it sorted; just remember, don't be surprised if Michael Moore shows up to create a half assed documentary about your experience with corrupt databases.
LMAO!! Best post I've read this morning.
__________________
I am not a programmer, nor do I play one on tv.
nefus is offline  
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
is this database relationship looks good? anybody can comment fairytale89 MySQL & Databases 1 01-12-2013 01:13 AM
How to use the Singleton design pattern Karl Advanced PHP Programming 27 10-22-2012 08:16 AM
No data inserted into database. Am I wrongdoing it? fairytale89 Absolute Beginners 3 03-29-2010 06:30 PM
[Tutorial] How to organize your classes | Part 1 Tanax Advanced PHP Programming 10 03-01-2009 10:08 PM
Adding Images to a database from a folder Rendair Advanced PHP Programming 3 01-13-2008 07:40 PM


All times are GMT. The time now is 05:54 PM.

 
     

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Inactive Reminders By Icora Web Design