I accidentally deleted some files... Please Help!!!!!

Joomla versions 2.5, 1.7 and 1.6 are all end-of-life since December 31st 2014 and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
Luna2011
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Tue Jul 15, 2014 2:43 am

I accidentally deleted some files... Please Help!!!!!

Post by Luna2011 » Tue Jul 15, 2014 5:16 am

Joomla 2.5
I accidentally deleted some files, now I can't access my site admin, it will not acknowledge my password and username.

I world like to re-install Joomla but I do not want to lose all my work. Please help!

when I go to my site I get this in red highlighted:


Table 'adv1412109170581.jos_contact_details' doesn't exist SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM jos_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by AND (contact.language in ('en-GB','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jos_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-07-15 05:07:51') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-07-15 05:07:51') AND a.language in ('en-GB','*') ORDER BY c.path, a.featured DESC, fp.ordering, a.created DESC LIMIT 0, 4 Table 'adv1412109170581.jos_contact_details' doesn't exist SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM jos_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by AND (contact.language in ('en-GB','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jos_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-07-15 05:07:51') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-07-15 05:07:51') AND a.language in ('en-GB','*') ORDER BY c.path, a.featured DESC, fp.ordering, a.created DESC

 
User avatar
ribo
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3446
Joined: Sun Jan 03, 2010 8:47 pm
Contact:

Re: I accidentally deleted some files... Please Help!!!!!

Post by ribo » Tue Jul 15, 2014 6:09 am

if your host makes daily back up ask them to give you a back up of your site and mysql to restore it
chat room spontes : http://www.spontes.com

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20042
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: I accidentally deleted some files... Please Help!!!!!

Post by leolam » Tue Jul 15, 2014 7:43 am

Download http://joomlacode.org/gf/download/frsre ... ackage.zip and extract locally. Upload in binary mode with ftp all files and folders (not the installation folder!) and overwrite. Thats should resolve this

Leo 8)
Joomla's #1 Professional Services Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

Luna2011
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Tue Jul 15, 2014 2:43 am

Re: I accidentally deleted some files... Please Help!!!!!

Post by Luna2011 » Tue Jul 15, 2014 4:58 pm

Thank you I will try that...

Luna2011
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Tue Jul 15, 2014 2:43 am

Re: I accidentally deleted some files... Please Help!!!!!

Post by Luna2011 » Tue Jul 15, 2014 6:00 pm

I do not have a backup file (bad bad).

I Downloaded http://joomlacode.org/gf/download/frsre ... ackage.zip and extracted locally and Uploaded with Filezilla, but still the same...

I might have to lose all my work and start all over again with a back this time :(

Luna2011
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Tue Jul 15, 2014 2:43 am

Re: I accidentally deleted some files... Please Help!!!!!

Post by Luna2011 » Tue Jul 15, 2014 6:02 pm

Any advise please?

User avatar
ribo
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3446
Joined: Sun Jan 03, 2010 8:47 pm
Contact:

Re: I accidentally deleted some files... Please Help!!!!!

Post by ribo » Tue Jul 15, 2014 6:40 pm

Luna2011 wrote:I do not have a backup file (bad bad).
did you ask your host about back up?
about that leo told you try also after overwrite the files of joomla, extension manager - database - fix.
after that clear cache and see if this can help
chat room spontes : http://www.spontes.com

pcmediahost
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Wed Apr 06, 2011 6:10 pm
Contact:

Re: I accidentally deleted some files... Please Help!!!!!

Post by pcmediahost » Sun Jul 27, 2014 11:12 pm

I tried to overwrite and it worked for me.

User avatar
jackrabbit
Joomla! Ace
Joomla! Ace
Posts: 1473
Joined: Thu May 21, 2009 3:12 am
Location: Florida
Contact:

Re: I accidentally deleted some files... Please Help!!!!!

Post by jackrabbit » Fri Aug 01, 2014 6:27 am

That database error is only the contact_details table and that can be easily recreated.

Did you delete the files via FTP or control panel file manager? If so, overwriting will restore the site.

No need to lose you data or files if you reinstall. If overwriting the system files did not work;
- Use phpmyadmin to export the current database or use the installer's DB backup during installation
- Use the same DB prefix of jos_ and do not install the demo data
- All your extension files will still be available so you no just need to restore the old DB inserts by importing the DB with phpmyadmin. You may need to do this per table else there will be ID conflicts and mySql will stop.
Reset Joomla super user password and username simply | http://cmsenergizer.com/website-energy- ... d-remotely

kayeshandra85
Joomla! Apprentice
Joomla! Apprentice
Posts: 25
Joined: Fri Jul 25, 2014 11:37 pm

Re: I accidentally deleted some files... Please Help!!!!!

Post by kayeshandra85 » Sat Aug 02, 2014 4:43 am

How is your site doing? Your hosting provider has a backup for your site. Just ask them.

 

Locked

Return to “Installation Joomla! 2.5”