please help - after uploading restore.sql - no products

Quote

Post by ideep13 » Wed Oct 21, 2015 5:20 am

I installed fresh clean install for 1.5.1.3. and removed every file from server and save it, I also saved a backup.sql and database file. After reinstalling it, and after uploading all the files back up, I can normally access to my admin folder. But when I try to restore my backup.sql file I keep getting this error:

Code: Select all

Notice: Error: Unknown column 'company_id' in 'field list'
Error No: 1054
INSERT INTO `oc_address` (`address_id`, `customer_id`, `firstname`, `lastname`, `company`, `company_id`, `tax_id`, `address_1`, `address_2`, `city`, `postcode`, `country_id`, `zone_id`) VALUES ('1', '1', 'test', 'test', '', '', '', 'test', '', 'tedt', '3230', '53', '848') in /home/content/70/8653470/html/system/database/mysql.php on line 49
Fatal error: Call to a member function get() on a non-object in /home/content/70/8653470/html/BROSTPK/index.php on line 83
And under admin folder I can see this error:
Warning: file_put_contents(): Only 0 of 1101 bytes written, possibly out of free disk space in /home/content/70/8653470/html/vqmod/vqmod.php on line 325
Everything is now blanked. No products, no costumers..

Could please someone help me. I have saved my database file as well. Is it possible to have a store online like it used to be.. please help me.. I am so stressed over this..

I am offline now for two days, which is a big loss for my firm.

Your help is much appreciated,

Thank you,

Best regards
User avatar
ideep13
Active Member
Posts
288
Joined
Mon Jun 18, 2012 2:47 am
Top

Re: please help - after uploading restore.sql - no products

Quote

Post by EvolveWebHosting » Wed Oct 21, 2015 9:12 am

It should be possible to recover but you're going to have to give someone you trust access to restore everything. Does your hosting company have a full backup of your account that they can restore? That would be the easiest method.

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhosting.com

User avatar
EvolveWebHosting
Active Member
Posts
1468
Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA
Top

Re: please help - after uploading restore.sql - no products

Quote

Post by ideep13 » Wed Oct 21, 2015 2:56 pm

Hi,

No, they don't don't. I downloaded admin, catalog, system and image folder and other files on my computer as a backup.

The thing is I wanted to upgrade the whole thing to 2.0. with totally new theme, but than everything went wrong.

Luckily I saved everything before doing that.

After I couldn't make it to work on 2.0. I deleted everything and uploaded all the files on server.

And this is the result

Code: Select all

Notice: Error: Unknown column 'company_id' in 'field list'
Error No: 1054
INSERT INTO `oc_address` (`address_id`, `customer_id`, `firstname`, `lastname`, `company`, `company_id`, `tax_id`, `address_1`, `address_2`, `city`, `postcode`, `country_id`, `zone_id`) VALUES ('1', '1', 'test', 'test', '', '', '', 'test', '', 'tedt', '3230', '53', '848') in /home/content/70/8653470/html/system/database/mysql.php on line 49
Fatal error: Call to a member function get() on a non-object in /home/content/70/8653470/html/BROSTPK/index.php on line 83
and in admin I noticed this as well

Code: Select all

Warning: file_put_contents(): Only 0 of 1101 bytes written, possibly out of free disk space in /home/content/70/8653470/html/vqmod/vqmod.php on line 325
My heart is pounding fast for three days now, I am going to have a heart attack if I can't fix this. :'(

I have a hosting with godaddy. Do you think if I go to File manager and enable history view and than click restore to the files changed, will anything happen at all.. I don't understand, because nothing has changed if I am copying the original files..

I think something is wrong with a database?

Who to trust? Who can help me?
User avatar
ideep13
Active Member
Posts
288
Joined
Mon Jun 18, 2012 2:47 am
Top

Re: please help - after uploading restore.sql - no products

Quote

Post by EvolveWebHosting » Thu Oct 22, 2015 8:36 am

Did you run the upgrade script for 2.0? If you did, the database was modified and that's the reason it won't work when you roll back to 1.5

Who to trust to fix it? We could look at it (not for free) or you could reach out to any of the other developers that you see on this forum.

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhosting.com

User avatar
EvolveWebHosting
Active Member
Posts
1468
Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA
Top

Re: please help - after uploading restore.sql - no products

Quote

Post by victorj » Sun Oct 25, 2015 4:36 am

there is a difference in database files, when reinstalling you did nit set the database prefix the same to the old database.
result database can not be imported from oc admin

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com

User avatar
victorj
Expert Member
Posts
4299
Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland
Top

Re: please help - after uploading restore.sql - no products

Quote

Post by ideep13 » Sun Oct 25, 2015 2:55 pm

victorj wrote:there is a difference in database files, when reinstalling you did nit set the database prefix the same to the old database.
result database can not be imported from oc admin
the database prefix was oc_

it stayed the same..

so what should I do? I just want the old site like it used to be.. I copied everything, I also have both sql files untouched..

so where should I change this? I gave Evolve all my username and passwords but no resolved issue here.. could you please help me to solve this issue asap.. my site is now down for 7 days and christmas is coming..

I wanted to pay for this, but I need my site to be online today!
User avatar
ideep13
Active Member
Posts
288
Joined
Mon Jun 18, 2012 2:47 am
Top

Re: please help - after uploading restore.sql - no products

Quote

Post by IP_CAM » Sun Oct 25, 2015 8:38 pm

you seem to have screwed up, badly, trying, to get a new shop, just before your SEASON SALES start. And you did NOT follow the rules, either, by paying around, with unfamilar THINGS. Therefore, I assume, you'll need professional Support, especially under the aspect, that you try to still use an already relavitely outdated OC version. At least, if you really care, to get it done, before the winter arrives.
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

User avatar
IP_CAM
Legendary Member
Posts
13059
Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Top

Re: please help - after uploading restore.sql - no products

Quote

Post by ideep13 » Mon Oct 26, 2015 12:38 pm

Just to let you know that nothing is screwed up badly, everything worked out - thanks to Victor 8)

What I needed to do is to delete a database on server and import my old one..

Yes it was really a bad mistake doing this before christmas.. well everyone make mistakes, this is a lesson. :)
I still need help to update my site with newest opencart and a new theme.. maybe after holidays in January and def we need to move the site from godaddy to another hosting.

Is Victor interested doing this job?
User avatar
ideep13
Active Member
Posts
288
Joined
Mon Jun 18, 2012 2:47 am
Top
Post Reply
Return to “Installation, Upgrade, & Config Support”
Who is online

Users browsing this forum: No registered users and 8 guests