Newbie problem ‘Table doesn’t exist’ on first run
Archived from the Xataface Users forum.
PanTau — Sun Jul 31, 2011 1:42 am
Hello.
I am new to xataface. I got everything running fine in my local XAMP-installation but when I moved
to the server I get this fatal error:
Fatal error: Error performing mysql query to get column information from table ‘Log’. The mysql error returned was : ‘Table ‘db372613171.Log’ doesn’t exist’.
On line 477 of file /homepages/26/d31129724/htdocs/hoalb2b/xataface/Dataface/Table.php in function printStackTrace()
On line 2375 of file /homepages/26/d31129724/htdocs/hoalb2b/xataface/Dataface/Table.php in function Dataface_Table(Log,Resource id #10,)
On line 975 of file /homepages/26/d31129724/htdocs/hoalb2b/xataface/Dataface/Application.php in function loadTable(Log)
On line 1726 of file /homepages/26/d31129724/htdocs/hoalb2b/xataface/Dataface/Application.php in function handleRequest()
On line 5 of file /homepages/26/d31129724/htdocs/hoalb2b/dbadmin/index.php in function display()
in /homepages/26/d31129724/htdocs/hoalb2b/xataface/Dataface/Table.php on line 477
local system: PHP 5.3.1, MySQL 5.1.41
server: PHP 5.2.17, MySQL 5.0
The database structure is exactly the same on both machines and the table mentioned definitly exists.
I already searched and found similar messages in the forum but - sorry - none of the comments helped.
Any help very much appreciated as xataface seems to be a great solution and I really want to get it running.
Thanks!
ADobkin — Sun Jul 31, 2011 9:59 am
Hi PanTau,
This sounds like either a permissions problem or a typo in the database name. Are you sure that “db372613171” is the correct name for your database? Does the “Log” table start with a capital “L”? You can check for a permissions issue by logging in with the same username and password that you configured in Xataface, but instead connect with either a command-line MySQL client or a GUI like phpMyAdmin, and confirm that you are able to open that table with the same account.
Alan
PanTau — Mon Aug 01, 2011 12:04 am
Hi Alan.
Thanks a lot It was the capital “L” issue. I recognized that “L” was wrong but didn’t know where it came from.
Found it in conf.ini. Now the live-installation is running just as fine as my local one.
Many thanks again.
PanTau