MySQL import problems
7 posts by 3 authors in: Forums > CMS Builder
Last Post: November 16, 2009 (RSS)
By studio-a - November 3, 2009 - edited: November 3, 2009
Problems:
---------------------------------------------------------------
01. IMPORTANT: After exporting our database from our local PC phpMyAdmin and then importing our database to our Unix Server using phpMyAdmin only one table is being displayed within CMS Builder application. However, ALL of the tables are displayed within phpMyAdmin 9both locally and on the web server)? The table that is displayed within cmsBuilder is the user_accounts table. We even changed, modified a user on the Local PC then exported the database and re-imported to our web server via phpMyAdmin and all the tables are there with the updated information. We then logged into cmsBuilder and still only the ONE table (or section - user_accounts) is displayed along with the updated information for that table.
We added a section with cmsBuilder from our web server, then exported the database via phpMyAdmin (from our web server) and then imported it to our local PC and both cmsBuilder and phpMyAdmin sees the changes. It's only on our web server that cmsBuilder is NOT seeing all the tables for this database.
If we create a section on our web server the database and cmsBuilder sees the information. But we cannot not always build websites from our web server. If phpMyAdmin is seeing all the tables and their data it's got to be something with cmsBuilder? Yet, then why does cmsBuilder function, but only displays ONE table of information from the imported database?
---------------------------------------------------------------
02. We are periodically experiencing an error page message stating "Couldn't Find table!" after saving sections within a Group Menu while using the cmsBuilder v1.36 application. We have to close the browser and reopening the cmsBuilder application. We did reboot the PC just to clear it's paging file and such. Still occurs every now and then.
PLEASE NOTE:
- When using v1.36 CMS Builder on a “local machine” we are using win wamp with phpMyAdmin.
- We are running different version of phpMyAdmin (local machine is newer than web server). However, we have made the compatible MySQL file to match the web server version as a second test, still same problem. Again, if cmsBuilder is displaying the one table (section) for the website it must be recognizing the database.
Your help is GREATLY appreciated!
studio-a
Re: [studio-a] MySQL import problems
By Dave - November 3, 2009
Let's start with the missing tables problem.
Make sure you've copied your schema files from /cmsAdmin/data/schema/ on your local server to the same folder on your unix server.
If that doesn't fix it, check if the unix and local servers are using different table prefixes (Displayed under: Admin > General > Database Settings).
Let me know what you find out.
interactivetools.com
Re: [studio-a] MySQL import problems
By studio-a - November 3, 2009 - edited: November 3, 2009
[font "Calibri"]
After reading your reply we realized we did not transfer those files; problem solved. I guess the new features (Group Menus) and such deferred our attention - nice feature! Out of curiosity, should members send their questions to the forum or interactivetools.com support? We received a FAST response from you within the forum yet have not heard anything from sending a support ticket (although it’s only been a day).
[font "Calibri"]
As for the error message (“Couldn’t Find Table!”) when saving sections within a Group Menu please let us know your feedback.
Thanks for your help.
[font "Calibri"]studio-a
Re: [studio-a] MySQL import problems
By Donna - November 5, 2009 - edited: November 5, 2009
Generally, you'll always want to post to the forums first -- as you noticed, response time can be a bit faster, especially since some of our other users might be able to answer questions as well.
You also don't want to send in an email AND a forum post, as having multiple people working on one problem can cause a lot of confusion.
If we can't figure it out from a forum post, we'll ask you to send us an email at that point so we can take a closer look. :)
--
support@interactivetools.com
Re: [studio-a] MySQL import problems
By Dave - November 5, 2009
I haven't heard of that one before. Is it easy to reproduce or does it just happen once in a while? And is the server a windows server or slower than usual?
It looks like that error is from /cmsAdmin/lib/menus/database/editTable_functions.php
Let me know on the above questions and also the name of the table. It should be in the URL when you get the error like this: ?menu=database&action=editTable&tableName=news
interactivetools.com
Re: [Dave] MySQL import problems
By studio-a - November 14, 2009 - edited: November 14, 2009
Since this posting we have NOT experienced the error again, odd. It happened a few times.
Do you think it could have been a combination of updating databases and forgetting to update the cmsAdmin/data/schema/ files? To answer your question Dave, no, there was no table name - just "[font "Verdana"]Couldn’t Find Table!" statement (as if it was a default error display). As for the windows server - it could have been slower than usual, we don't recall.
Nonetheless, we have not experienced the problem since that day.
Thanks for all your replies.
studio-a
Re: [studio-a] MySQL import problems
By Dave - November 16, 2009
Let me know if it comes up again. I've added the tablename to that error message to help make it easier to debug if it comes up again.
Thanks!
interactivetools.com