Newbie problem 'Table doesn't exist' on first run

A place for users and developers of the Xataface to discuss and receive support.

Newbie problem 'Table doesn't exist' on first run

Postby 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!
PanTau
 
Posts: 2
Joined: Sun Jul 31, 2011 1:27 am

Re: Newbie problem 'Table doesn't exist' on first run

Postby 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
ADobkin
 
Posts: 195
Joined: Mon Oct 22, 2007 7:31 pm
Location: Atlanta, GA, USA

Re: Newbie problem 'Table doesn't exist' on first run

Postby PanTau » Mon Aug 01, 2011 12:04 am

Hi Alan.

Thanks a lot :D 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
PanTau
 
Posts: 2
Joined: Sun Jul 31, 2011 1:27 am


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 29 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved