After my server restarted Concrete is reporting tables not found? HELP!!!

Permalink
My development server had to be restarted. I stopped all services correctly before doing this.

Now when i go tohttp://localhost/myproject/index.php... i get the following:

An exception occurred while executing 'select pkgID, pkgName, pkgIsInstalled, pkgDescription, pkgVersion, pkgHandle, pkgDateInstalled from Packages where pkgIsInstalled = ? order by pkgID asc' with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'concrete.Packages' doesn't exist.

Before i installed concrete onto my localhost i put this in the my.ini file as i am developing on windows:

lower_case_table_names=0

Please help!

sparrowwebservices
 
mkly replied on at Permalink Reply
mkly
That error shows up when the database concrete5 is pointed to exists but concrete5 is not installed into the database. Are you sure the server you were using had persistent storage for your database? You might want to check with your host to see what might have happened to your database.
theneptune replied on at Permalink Reply
theneptune
First you check that concrete5 is installed or not in your new server database. I think it is missing. Check it and if not then install concrete5 there.
sparrowwebservices replied on at Permalink Reply 3 Attachments
sparrowwebservices
Thanks for the reply guys. A bit more information for you.

This isn't a live internet based server. This is on a localhost server that i have at home for developing the website.

I am sure that the database is there as i have been working on it for the last 3 weeks and am only getting this problem after i restarted the server. I can also see the tables and database in myPHPAdmin (see attached screen shot).

I do however get the error (see screenshot myphpAdminError) when i try and open one of the tables in myPHPAdmin.

Hopefully the screenshots i have attached will help explain my problem a little bit more.

Thanks again
theneptune replied on at Permalink Reply
theneptune
Where you have attached the screen shots? Please attach it.
theneptune replied on at Permalink Reply
theneptune
Oh...sorry I have got it.
Jupiter replied on at Permalink Reply
Jupiter
Hi
sparrowwebservices,

please repair the tables of your database from phpmyadmin...i think this will help you

Regards
Jupiter
sparrowwebservices replied on at Permalink Reply
sparrowwebservices
Hi Jupiter,

Thanks for your reply.

I am a little confused. In my previous screenshot you can see that in the left hand pane all the tables are listed. However when i click on the database on the main screen i only get 2 tables listed so i am unable to select all tables and repair?
Jupiter replied on at Permalink Reply
Jupiter
ohhh...you don't have all the tables...so you have to reinstall concrete5
sparrowwebservices replied on at Permalink Reply
sparrowwebservices
It would appear that way, although they are all showing in the bar on the left as you can see in previous screenshot.

Does that mean then i am going to loose all the website data??

If i go into the data folder of mysql all the files for all the tables are actually there??
Jupiter replied on at Permalink Reply
Jupiter
Yes i think you loose your all website data