Error 1146 - Please help

[Kjolebutikken]

I get this error and I have been trying the whole day to figure out what to do. Can anyone please help me. All answers will be most appreciated. here is the error:

 

1146 - Table 'kjolebutikken_c.sessions' doesn't exist

 

select value from sessions where sesskey = '3f9da638205183d9f99c53519b6e79eb' and expiry > '1134249395'

 

[TEP STOP]

 

Kjolebutikken

[ozcsys]

I get this error and I have been trying the whole day to figure out what to do. Can anyone please help me. All answers will be most appreciated. here is the error:

 

1146 - Table 'kjolebutikken_c.sessions' doesn't exist

 

select value from sessions where sesskey = '3f9da638205183d9f99c53519b6e79eb' and expiry > '1134249395'

 

[TEP STOP]

 

Kjolebutikken

 

Is the table in your database? It probably is but I would doublecheck and make sure.

 

On another note, looking at your posts from the last couple of days you seem to be running into a lot of problems and it may well be that you are trying to make a lot of different changes in a short time. You may want to make a change and make sure that it is working correctly before moving on to something else.

 

Something else is you should try and document your changes so that later on you can look and see what you did months or a year from now ( or even next week)

[Kjolebutikken]

Is the table in your database? It probably is but I would doublecheck and make sure.

 

On another note, looking at your posts from the last couple of days you seem to be running into a lot of problems and it may well be that you are trying to make a lot of different changes in a short time. You may want to make a change and make sure that it is working correctly before moving on to something else.

 

Something else is you should try and document your changes so that later on you can look and see what you did months or a year from now ( or even next week)

 

Thank you for your good advice. I certainly will make me a log for the changes I do. hav not done other changes than installing the norwegian languagepack and all worked fine. Problem started when I was going to change the text in the stores homepage (index.php). I made a backup in admin backup tool. I started making changes in index.php. I guess I deleted too much. After saving I got blank screen all over, both admin and my store (catalog). Could not enter either one.

 

Therefore I restored the latest backup from admin tool. This did not work.

Then I tried to run this backup file in SQL in phpmyadmin. Nothing happened.

Then I deleted the index-php file and uploaded the original index.php file. Nothing happened.

 

have tried all day different things, but still the same 1146 message.

 

I would appreciate if you could advice me about what to correct in what files to make this work again. Do I have to create a new kjolebutikken_c.sessions file? If so , how do I do that? Or do I have to reinstall all?

 

Thank you.

Kjolebutikken

[ozcsys]

Thank you for your good advice. I certainly will make me a log for the changes I do. hav not done other changes than installing the norwegian languagepack and all worked fine. Problem started when I was going to change the text in the stores homepage (index.php). I made a backup in admin backup tool. I started making changes in index.php. I guess I deleted too much. After saving I got blank screen all over, both admin and my store (catalog). Could not enter either one.

 

Therefore I restored the latest backup from admin tool. This did not work.

Then I tried to run this backup file in SQL in phpmyadmin. Nothing happened.

Then I deleted the index-php file and uploaded the original index.php file. Nothing happened.

 

have tried all day different things, but still the same 1146 message.

 

I would appreciate if you could advice me about what to correct in what files to make this work again. Do I have to create a new kjolebutikken_c.sessions file? If so , how do I do that? Or do I have to reinstall all?

 

Thank you.

Kjolebutikken

 

 

One thing to keep in mind is that you have two index.php ( or actuallymore as you have one for each lang) files in each section of your site( admin and catalog) one is the language file and one is the working file. If you upload the wrong one to the wrong location you will have plenty of problems.

 

If uploading the original file did not fix your problem try it again paying carefule attention to what file is going where

 

admin/index.php to admin/index.php

 

admin/includes/languages/english.php to admin/includes/languages/english.php

 

etc etc

 

any time you mess up a file and upload the original and the problem does not go away then you have either made changes to other files as well that need to be removed or you have uploaded the wrong file to the wrong location.

 

 

 

concerning the admin and sql backups These only backup the database, they do not save any of your files!!!!

[Kjolebutikken]

One thing to keep in mind is that you have two index.php ( or actuallymore as you have one for each lang) files in each section of your site( admin and catalog) one is the language file and one is the working file. If you upload the wrong one to the wrong location you will have plenty of problems.

 

If uploading the original file did not fix your problem try it again paying carefule attention to what file is going where

 

admin/index.php to admin/index.php

 

admin/includes/languages/english.php to admin/includes/languages/english.php

 

etc etc

 

any time you mess up a file and upload the original and the problem does not go away then you have either made changes to other files as well that need to be removed or you have uploaded the wrong file to the wrong location.

concerning the admin and sql backups These only backup the database, they do not save any of your files!!!!

 

Thank you again, very good advices. I will try again to detele all 4 index.php files and upload all 4 originals again in the right places and see if that works.

 

One more question. I have decided to download my hole catalog folder to my computer often now in the beginning since most of the changes will be now starting up, and then on a continious basis for later. But what are the backups in admin for? Is this all the data of the products and pictures I put inn? How do I use these backup files later ?

 

Kjolebutikken:-)

[ozcsys]

Thank you again, very good advices. I will try again to detele all 4 index.php files and upload all 4 originals again in the right places and see if that works.

 

One more question. I have decided to download my hole catalog folder to my computer often now in the beginning since most of the changes will be now starting up, and then on a continious basis for later. But what are the backups in admin for? Is this all the data of the products and pictures I put inn? How do I use these backup files later ?

 

Kjolebutikken:-)

 

 

The backups in the admin are for your database. Basically this is all your product info as well as all your customer info. You can look at the database fields and see what kind of info is kept in the database. Depending on how busy your store is depends on how often this needs to be backup.

[Kjolebutikken]

The backups in the admin are for your database. Basically this is all your product info as well as all your customer info. You can look at the database fields and see what kind of info is kept in the database. Depending on how busy your store is depends on how often this needs to be backup.

 

OK, nice to know:-)

 

Just tried to change all 4 index.php files, but still same error. Think I maybe have to ceate the tabell that is asked for? If yes, do you know how to do that?

 

Kjolebutikken