Can't Register

sopangyu · **on:** October 08, 2007, 01:34:49 pm

I Can't register due to account problems ,My email is sopangyu@hotmail.com or sopangyu@sjc.edu.hk

Jps · **Reply #1 on:** October 08, 2007, 01:36:35 pm

Explain in details

... what did it say? "Email already used"?

dktc · **Reply #2 on:** October 08, 2007, 01:41:55 pm

Nope. No player with those email.

... but yes, give us more details if you will.

sopangyu · **Reply #3 on:** October 09, 2007, 02:27:04 pm

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/register.php on line 115

Notice: Query: INSERT INTO `users` (`email`, `pass`, `first_name`, `last_name`, `username`, `security`, `active`, `registration_date`, `airline_name`, `airline_code`, `airline_type`, `airline_cash`, `continent_no`, `reg_ip`, `airline_value`) VALUES ('sopangyu@sjc.edu.hk', '9477f28373ab52b539b65e19128d264f2b3c1434', 'So', 'Pang Yu Derek', 'sopangyu', '4', '', NOW(), 'L'Avion Voyager', 'LAV', '', '2000000', '3', '61.18.170.250', '19500000')
MySQL 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 'Avion Voyager', 'LAV', '', '2000000', '3', '61.18.170.250', '19500000')' at line 4 in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/register.php on line 162

You could not be registered due to a system error. We appologise for any inconvenience. Please try again, if problem persists report this error and any detail you can provide in the forums

Jps · **Reply #4 on:** October 09, 2007, 02:30:56 pm

Do you use Apple or PC?

Speed of Internet? Example: 104.0 Mbps

Internet Explorer, Firefox or other crappy explorers?

Who do you prefer to answer your question, Dktc or Stephen?

MrOrange or Skylite (pick one):

Thanks

dktc · **Reply #5 on:** October 09, 2007, 02:31:31 pm

THe registration script is broken. We are in the process of fixing it. Check back in 10 hours or so. Hopefully Will will get it done by then. If not, check back again in another 10 hours

MrOrange · **Reply #6 on:** October 09, 2007, 02:31:39 pm

You used L'Avion Voyager as airline name, correct? When you use an ' in the name, the MySQL query will be completely messed up because it uses ' as separators for values, IIRC. I had this problem so, so many times with other things. I think that might be the problem. Try registering without the ' in the name.

Jps · **Reply #7 on:** October 09, 2007, 02:32:54 pm

Doesn't matter with the '? Or does it?

MrOrange · **Reply #8 on:** October 09, 2007, 02:32:59 pm

@dktc: Don't know if you understand MySQL, but it seems like it doesn't understand (and it has a point) the extra '.

@JPS: I guess it does.

dktc · **Reply #9 on:** October 09, 2007, 02:34:39 pm

That ' is one problem. Yes, try omitting it.

Another one is that the registration is acting weird. I couldn't even get in with the bypass script after I registered a test account (on Will's request, which mean he / other admins has(ve) notice something abnormal there). So... :?

MrOrange · **Reply #10 on:** October 09, 2007, 02:35:56 pm

I haven't tried yet, but I might have to give it a go.

Jps · **Reply #11 on:** October 09, 2007, 02:37:21 pm

So you can't register in AM for 10 hours..

(that's a bad experience for a first time joiner in AM)

sopangyu · **Reply #12 on:** October 09, 2007, 02:51:31 pm

Anyway,Thanks for your reply and helps

dktc · **Reply #13 on:** October 09, 2007, 02:53:28 pm

Quote from: "Jps"

So you can't register in AM for 10 hours..

(that's a bad experience for a first time joiner in AM)

It is not about the delay. It is about how we treat our guest during the delays.

As the airline pilots love to say, "we will keep you all updated on the situation. We would try to get it working as soon as we could."

It is the spirit that counts

Jps · **Reply #14 on:** October 09, 2007, 02:55:48 pm

Quote from: "sopangyu"

Anyway,Thanks for your reply and helps

NP..

@Dktc How will you help me get pass this terribly long reset

..