28, May 2012

register.php, login.php fails - webmaster forum

 
Webdigity webmaster forums
[ Home | Help | Search | Forum's Shop | Archive | Login | Register | Webmaster Directory ]
Webdigity Webmaster Forums  >  Web Development  >  PhP  >  PHP classes @finalwebsites.com  >  Access_user Class (Moderator: Olaf)
Topic: register.php, login.php fails
« previous next »
Pages: [1] Print

Author Topic: register.php, login.php fails  (Read 2498 times)
Atari ST fan
*
Posts: 8
64 credits
Members referred : 0


« on: Oct 22, 2007, 01:05:31 pm »

Dear Forum,  I am having a hard time with access_user.  I have moved it to a new server and when I try registering a user or login I get this error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near " -main.users WHERE email = 'jgnasser@abcl.com' OR login = 'jgna" and registration or login fails.  Any ideas what could be wrong?
Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6691
34714 credits
Members referred : 374


It's time to use PHP5!


« Reply #1 on: Oct 22, 2007, 01:46:22 pm »

Hi,

you are using this kind of naming convention for table names:

database.table

this is not allowed in your current configuration, check the source for information about how to call the database (config and AU class file)

Atari ST fan
*
Posts: 8
64 credits
Members referred : 0


« Reply #2 on: Oct 22, 2007, 02:14:29 pm »

do you mean access_user does not support database.name or my new host may not support that?  Thanks.
Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6691
34714 credits
Members referred : 374


It's time to use PHP5!


« Reply #3 on: Oct 22, 2007, 02:22:57 pm »

do you mean access_user does not support database.name or my new host may not support that?  Thanks.

your host doesn't support this (your db user doesn't have the rights)

Atari ST fan
*
Posts: 8
64 credits
Members referred : 0


« Reply #4 on: Oct 22, 2007, 03:07:35 pm »

Thanks, I get what you mean.  My new server may not support database.table, will check that.
Trackback URI for this entry : http://www.webdigity.com/trackback.php?topic=7272
Tags : login register Bookmark this thread : Digg Del.icio.us Dzone more....

Pages: [1] Print 
Webdigity Webmaster Forums  >  Web Development  >  PhP  >  PHP classes @finalwebsites.com  >  Access_user Class (Moderator: Olaf)
Topic: register.php, login.php fails
« previous next »
Jump to:
User Area
Welcome, Guest. Please login or register.
Did you miss your activation email?
May 28, 2012, 09:37:47 pm





Login with username, password and session length

Donate to our community, and get a permanent link back to your site!

Donate to our community, and get a permanent link back to your site!






Web Design Gallery · Whois Lookup · Pagerank · Tag Browsing · Lo-fi version · Syndication · Webmaster forum history · Advertise
Developed by HumanWorks © 2005 - 2012 Webdigity webmaster community · sublime directory
Webdigity Webmaster Forums | Powered by SMF 1.0.12. © 2001-2005, Lewis Media. All Rights Reserved.