[HELP] Failed to create a new account, please try again later

[PlugMan]

Hello EPVP

I'm trying to run a register script released on elitepvp " abrasive_registration "
And i'm having problems with creating new account

my SQL user is : Shaiya
and SQL PSW : Shaiya123
i've configure it on PHP

db.config.php

 Spoiler

<?php
// Verify the php_mssql libary is installed and enabled.
if(!function_exists('mssql_connect')){
echo 'You must have the php_mssql library for Apache installed and enabled to connect to an MSSQL database. Uncomment the line that says extension=php_mssql.dll in your php.ini (XAMPP/WAMP only). This requires a restart of the Apache service to take effect.'; die();
}
// Database configuration parameters
$db_host = '127.0.0.1';
$db_user = 'Shaiya';
$db_pass = 'Shaiya123';

/**
* Sanitize user input to prevent SQL injection. Use this on ALL user input!
* This function is from CodeIgniter.
* I researched other methods of doing this, and this looked the most solid to me - Abrasive
* @ string $data
* @ string
*/
function mssql_escape_string($data) {
if(!isset($data) or empty($data)) return '';
if(is_numeric($data)) return $data;
$non_displayables = array(
'/%0[0-8bcef]/', // url encoded 00-08, 11, 12, 14, 15
'/%1[0-9a-f]/', // url encoded 16-31
'/[\x00-\x08]/', // 00-08
'/\x0b/', // 11
'/\x0c/', // 12
'/[\x0e-\x1f]/' // 14-31
);
foreach($non_displayables as $regex)
$data = preg_replace($regex,'',$data);
$data = str_replace("'","''",$data);
return $data;
}
?>

How can i solve this ?
i'm running on my local machine its not a public server

Thank you all for helping new members like me

[XareL]

// This means the insert statement is probably not valid for your database. Fix the query or fix your database, your choice

[PlugMan]

This is the error bro...

[XareL]

[PlugMan]

Originally Posted by XareL

// This means the insert statement is probably not valid for your database. Fix the query or fix your database, your choice

Help me please , for unknow reason i can't use skype , let me see if i can log in discord

Thanks XreaL , Problem SOLVED !

[nephren]

Originally Posted by PlugMan

[CENTER][SIZE="4"]
my SQL user is : Shaiya
and SQL PSW : Shaiya123
i've configure it on PHP

Just as an advice: If it runs local, you could leave it. But you should definitely change your credentials to something more "secure". Otherwise it's an invitation for others to join your database.

More here:

[PlugMan]

It's just a test server on my Computer @

Thanks a lot for helping new member's like me ^_^

[nephren]

not for that, you're very welcome

[MC Flip]

The error means that the script does not match your table definition, or the other way around, depending on which one you want to change.

As for security, you can disable remote access to SQL ports in your firewall. However, it is still recommended to use different credentials and not Shaiya/Shaiya123