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!
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!
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.
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.
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
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
Where you have attached the screen shots? Please attach it.
Oh...sorry I have got it.
Hi
sparrowwebservices,
please repair the tables of your database from phpmyadmin...i think this will help you
Regards
Jupiter
sparrowwebservices,
please repair the tables of your database from phpmyadmin...i think this will help you
Regards
Jupiter
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?
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?
ohhh...you don't have all the tables...so you have to reinstall concrete5
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??
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??
Yes i think you loose your all website data