8, January 2009

register.php, login.php fails - webmaster forum

 
Webdigity webmaster forums
This forum shares its ad revenue with its members!
[ 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 901 times)
Atari ST fan
*
Posts: 8
64 credits
Members referred : 0


« on: Oct 22, 2007, 02: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: 6557
40174 credits
Members referred : 374


It's time to use PHP5!


« Reply #1 on: Oct 22, 2007, 02: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)


Last blog : Just a better Internet portal provided by Google
Atari ST fan
*
Posts: 8
64 credits
Members referred : 0


« Reply #2 on: Oct 22, 2007, 03: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: 6557
40174 credits
Members referred : 374


It's time to use PHP5!


« Reply #3 on: Oct 22, 2007, 03: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)


Last blog : Just a better Internet portal provided by Google
Atari ST fan
*
Posts: 8
64 credits
Members referred : 0


« Reply #4 on: Oct 22, 2007, 04: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....

Topic sponsors:
Get a permanent link here for $1.99!


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?
Jan 08, 2009, 07:57:15 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!


Forum Statistics
Total Posts: 38.655
Total Topics: 7.772
Total Members: 4.659
Tutorials : 56
Resources : 143
Designs : 220
Latest Member: sardiniasarena

20 Guests, 4 Users online :

17 users online today:



Readers

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