• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

GESIOR ACC 8.6 + LAYOUT + ots8.6 + tutorial

Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list' in C:\Xampp\htdocs\pot\OTS_Account.php:237 Stack trace: #0 C:\Xampp\htdocs\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\Xampp\htdocs\install.php(573): OTS_Account->load(1) #2 {main} thrown in C:\Xampp\htdocs\pot\OTS_Account.php on line 237
Help?
 
Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list' in C:\Xampp\htdocs\pot\OTS_Account.php:237 Stack trace: #0 C:\Xampp\htdocs\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\Xampp\htdocs\install.php(573): OTS_Account->load(1) #2 {main} thrown in C:\Xampp\htdocs\pot\OTS_Account.php on line 237
Help?
Code:
alter table `accounts` add `vip_time` INT NOT NULL;
 
goto your phpmyadmin database, sql, paste that code
Okay, Done But Now This Pops-Up :S Can You Help Me With Last Step?
STEP 5
Set Admin Account

Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'field list' in C:\Xampp\htdocs\pot\OTS_Account.php:237 Stack trace: #0 C:\Xampp\htdocs\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\Xampp\htdocs\install.php(573): OTS_Account->load(1) #2 {main} thrown in C:\Xampp\htdocs\pot\OTS_Account.php on line 237
 
Okay, Done But Now This Pops-Up :S Can You Help Me With Last Step?
STEP 5
Set Admin Account

Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'field list' in C:\Xampp\htdocs\pot\OTS_Account.php:237 Stack trace: #0 C:\Xampp\htdocs\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\Xampp\htdocs\install.php(573): OTS_Account->load(1) #2 {main} thrown in C:\Xampp\htdocs\pot\OTS_Account.php on line 237
try
Code:
alter table `accounts` add `vip_time` INT NOT NULL;
 
Code:
alter table `accounts`  INT NOT NULL;
Static analysis:

1 errors were found during analysis.



  1. Unrecognized alter operation. (near "" at position 0)


SQL-fråga:

alter table `accounts` INT NOT NULL

MySQL sa:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INT NOT NULL' at line 1
 
dude i'm not trying to be mean but it's so obvious... go into your config.lua and go down to "mysql" part you'll figure it out.. it isn't rocket science
 
dude i'm not trying to be mean but it's so obvious... go into your config.lua and go down to "mysql" part you'll figure it out.. it isn't rocket science
Database error. Unknown database type in C:/Users/Slamos/Desktop/roxor/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""
I Do Have Mysql Putted In My Server Config :S
 
dude i'm not trying to be mean but it's so obvious... go into your config.lua and go down to "mysql" part you'll figure it out.. it isn't rocket science
Config
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "1337"
sqlFile = "mysql"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"
 
Back
Top