218503 URGENT: database problem

I have a site [url removed, login to view] it's a site for a world championship of gimnastic being held TODAY in my city.

Client couldn't save the results of yesterday's competition, someone edited the phpmyadmin of site and deleted the table "gp_results_entries_info" so on our private admin area when we tried to edit the results, we got this error:

SELECT [url removed, login to view] id, `cat_id`, `title` FROM gp_results_entries parent LEFT JOIN gp_results_entries_info child ON [url removed, login to view] = child.parent_id AND child.lang_id="es" ORDER BY position ASC

A friend programmer of mine, created that table again, but it looks like the fields are not correct and the frontend does not show the results correctly, and it does not allow to save description, edit title of competitions, or add any entry to the entry area.

Front page should look like:

[url removed, login to view]

Where the left sidebar where competition 1, 2, 3 is, should show the title on "gp_results_categories_info" table (this one not deleted)

BUT, since the "gp_results_entries_info" has been deleted, we have a problem. It's been created but my friend cannot find the exact problem why now we can't edit/upload data for the competition.

Can this be done? But can you just restore the table "gp_results_entries_info" so that the rest of the site info is there? I don't want the other content to be restored, otherwise I HAVE A BIG PROBLEM :(

So, what I need is to to able to make it work as it worked before, being able to successfully edit the title/description and upload pdf with results.

Right now I see at least the page (before I couldn't):

[url removed, login to view]

But I can't describe text or change titles or upload pdf, the admin area won't save what I enter.

Looking forward to hearing from you. Can you help me? I need to have this fixed in 3 hours maxium. It's 12:30 a.m GMT +1, for 15:30 GMT+1 maximum.

Kemahiran: Semua Boleh, MySQL, PHP

Lihat lagi: work competitions, why should we, where i can find programmer, where can i find programmer, what is database entry, what is a database programmer, programmer where i can find one, programmer competition, maximum problem, join the competition, find programmer friend, find a database programmer, data entry position description, com problem, can you find it competition, be the change you want to see in the world, asc it, child data entry, pdf to world, concurso, Competitions, php mysql join table, mysql join table, mysql general error, mysql table join

Tentang Majikan:
( 138 ulasan ) San Bartolome de Geneto, Spain

ID Projek: #1964736

Dianugerahkan kepada:


hi, ready to start. gmt+3. if you interested, choose me. regards, roberto

$65 USD dalam 0 hari
(256 Ulasan)