This topic is locked

Linux port failed

7/27/2008 7:31:08 PM
PHPRunner General questions
Z
zeitsprung author

I encountered a strange problem after moving all files generated by PHPR to a linux virtual appliance (VA LAMP). I made a sql dump which I imported on the linux box. After trying to login with username/password I got the following error:
Error type:

Error description: [color=#FF0000]Table 'rafq.LoginAttempts' doesn't exist

URL:

Error file: [color=#FF0000]/var/www/html/rafq/include/dbconnection.php

Error line:

[b]SQL query:
[color=#FF0000]select * from `ema_users` where `login_name`='Dieter' and `password`='xxxxxxxxxxxxxxxxxxxxxxxxxxxx'
Since the table's name is 'loginattempts', the table 'LoginAttempts' naturally can't be found.

Somewhere (expected in dbconnection.php) the table name changes.

But why does the identical fileset run error free on my XAMPP virtual box while it fails on my LAMP box?

I'm shure, Jane knows the answer... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=9106&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />

J
Jane 7/28/2008

Hi,
this error is dependent on MySQL settings.

Try to convert table name to lowercase in the event code and rebuild your project.