[B]Fatal error[/B]: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'otserv.z_shop_offer' doesn't exist' in C:\xampp\htdocs\shopsystem.php:55 Stack trace: #0 C:\xampp\htdocs\shopsystem.php(55): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\shopsystem.php(99): getOfferArray() #2 C:\xampp\htdocs\index.php(184): include('C:\xampp\htdocs...') #3 {main} thrown in [B]C:\xampp\htdocs\shopsystem.php[/B] on line [B]55[/B]
$offer_list = $GLOBALS['SQL']->query('SELECT * FROM
'.$GLOBALS['SQL']->tableName('z_shop_offer').';');
C:/Documents and Settings/Administrator/ot-server/My Ot-server are on server1 and your aac are on server2.
When the aac wants the server path, how should it be then?
Example:
server1-ip/Documents and Settings/Administrator/Desktop/ot-server/
or am I totally wrong?
Because it says: Can't load config.lua file at server1-ip/Documents and Settings/Administrator/Desktop/ot-server/config.lua
Please help me.
C:/Documents and Settings/Administrator/ot-server/
Don't write config.lua in the server path.
I think im missing a table on the database. (otserv.z_shop_offer)
How do I add it?
When I try to access ?subtopic=shopsystem then I get this error..
Code:[B]Fatal error[/B]: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'otserv.z_shop_offer' doesn't exist' in C:\xampp\htdocs\shopsystem.php:55 Stack trace: #0 C:\xampp\htdocs\shopsystem.php(55): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\shopsystem.php(99): getOfferArray() #2 C:\xampp\htdocs\index.php(184): include('C:\xampp\htdocs...') #3 {main} thrown in [B]C:\xampp\htdocs\shopsystem.php[/B] on line [B]55[/B]
All those lines tries to load the table..
C:\xampp\htdocs\shopsystem.php:55
Code:$offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').';');
CREATE TABLE `z_shop_offer` (
`id` int(11) NOT NULL auto_increment,
`points` int(11) NOT NULL default '0',
`itemid1` int(11) NOT NULL default '0',
`count1` int(11) NOT NULL default '0',
`itemid2` int(11) NOT NULL default '0',
`count2` int(11) NOT NULL default '0',
`offer_type` varchar(255) default NULL,
`offer_description` text NOT NULL,
`offer_name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
You can remove that line. About the blue bottom, go to config.lua and find this:I have:
Warning: Error parsing C:/Documents and Settings/Markus/Skrivbord/Tja/config.lua on line 179 in C:\xampp\htdocs\config-and-functions.php on line 13
@ the top of my aac.
Line 179 in my config.lua are:
-- 60 * 1000 / 3 = 20 / 4 = 5 seconds (3 * 4 = 12 minutes for 1 stamina minute).
When I removed that line as someone said I should the error dissapear, BUT the login buttom are just blue now and when I press the buttom I come to http://otland.net/
Someone know how to fix it?
Thanks for help.
-- Connection config
worldId = 0
ip = "http://otland.net"
port = 7171
loginTries = 10
retryTimeout = 5 * 1000
if(file_exists($config['site']['server_path'].'config.lua')) {
$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
if(isset($config['server']['sqlType'])) {
$config['site']['install'] = 2;
saveconfig_ini($config['site']);
echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and looks like fine server config file. Now you can check database('.$config['server']['sqlType'].') connection: <a href="install.php?page=step&step=2">STEP 2 - check database connection</a>';
}
else
{
echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and it\'s not valid TFS config.lua file. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a> If it\'s your config.lua file from TFS contact with acc. maker author.';
}
}
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "xxxxxxx"
sqlDatabase = "otserv"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 60
mysqlReadTimeout = 10
optimizeDatabaseAtStartup = "yes"
passwordType = "plain"
My config.lua file from TFS 0.3.2 has 202 lines... last:Im having troubles with this part of the install.php
Code:if(file_exists($config['site']['server_path'].'config.lua')) { $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua'); if(isset($config['server']['sqlType'])) { $config['site']['install'] = 2; saveconfig_ini($config['site']); echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and looks like fine server config file. Now you can check database('.$config['server']['sqlType'].') connection: <a href="install.php?page=step&step=2">STEP 2 - check database connection</a>'; } else { echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and it\'s not valid TFS config.lua file. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a> If it\'s your config.lua file from TFS contact with acc. maker author.'; } }
Btw Im getting the "looks like fine config bla bla you can check the database..." SO I know the problem is only in the "PARSE" part as the error says
Warning: Error parsing C:/Users/David/Desktop/0.3.2/config.lua on line 243 in C:\Users\David\Desktop\OT\XAMP\xampp\htdocs\otpage \install.php on line 150
Any suggestions on what my error might be ?
By the way here is my configlua just in case.
Code:sqlType = "mysql" sqlHost = "localhost" sqlPort = 3306 sqlUser = "root" sqlPass = "xxxxxxx" sqlDatabase = "otserv" sqlFile = "forgottenserver.s3db" sqlKeepAlive = 60 mysqlReadTimeout = 10 optimizeDatabaseAtStartup = "yes" passwordType = "plain"
Find line:...
-- Logs
-- NOTE: This kind of logging does not work in GUI version.
-- For such, please compile the software with __GUI_LOGS__ flag.
runeFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = "no"
-- called "exception tracer" (__EXCEPTION_TRACER__ flag)
My config.lua file from TFS 0.3.2 has 202 lines... last:
Find line:
in config.lua and deletePHP:-- called "exception tracer" (__EXCEPTION_TRACER__ flag)
I have a problem!
When i going to Edit Config because i want to give my Site and there comes a empty window!
Why?
Please help me