第 1 頁 (共 1 頁)
[問題] Vault 無法更新股票總數及董事長名單
發表於 : 2004-08-17 19:55
由 a97cck
問題外掛：Vault1.0
參考連結：
http://phpbb-tw.net/phpbb/viewtopic.php?t=24523
使用版本：php BB 2.0.10
網站位置：
http://plk2a.freelinuxhost.com/BB/index.php
狀況描述：
I have installed it and when I buy a stock,it shows
無法更新股票總數及董事長名單
DEBUG MODE
SQL Error : 1064 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 'WHERE stock_id = 1' at line 4
UPDATE phpbb_vault_exchange SET stock_total = 30 - 0, chairman = WHERE stock_id = 1
Line : 419
File : /home/www/plk2a.freelinuxhost.com/BB/vault.php
補充：
Cash Mod ,watched list mod ,flash cash mod and Vault1.0
I am looking forward for the help.Thx
發表於 : 2004-08-19 10:10
由 a97cck
Hey Please help!!!!!!!!!!!!!
please!
Re: [問題] Vault 無法更新股票總數及董事長名單
發表於 : 2004-08-19 12:41
由 問題狂
a97cck 寫:問題外掛：Vault1.0
參考連結：
http://phpbb-tw.net/phpbb/viewtopic.php?t=24523
使用版本：php BB 2.0.10
網站位置：
http://plk2a.freelinuxhost.com/BB/index.php
狀況描述：
I have installed it and when I buy a stock,it shows
無法更新股票總數及董事長名單
DEBUG MODE
SQL Error : 1064 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 'WHERE stock_id = 1' at line 4
UPDATE phpbb_vault_exchange SET stock_total = 30 - 0, chairman = WHERE stock_id = 1
Line : 419
File : /home/www/plk2a.freelinuxhost.com/BB/vault.php
補充：
Cash Mod ,watched list mod ,flash cash mod and Vault1.0
I am looking forward for the help.Thx
我也是..
按下後便出現此訊息..
是不是應為我把所有的"user_points"改成"user_money"的原因呢?
發表於 : 2004-08-19 13:02
由 pc123
不是.........
是程式的問題...
我之前也裝過.
好像有人有解決的辦法...我用過.....
發表於 : 2004-08-19 13:46
由 問題狂
可是搜尋沒找到..
發表於 : 2004-09-07 12:40
由 t119_net
change mode of root/cache/vault_config.php -> 666
i have similar error and now can run no problem...
good luck
發表於 : 2004-09-08 20:47
由 a97cck
thx for your help but i am that ther is no improvment....
發表於 : 2004-09-09 12:58
由 t119_net
just want to know ...
have you add new stock on it ??
I have the same problem again while add new stock...
but when i use the name of new stock without " " (space) then it seems ok.....
i think that is the program problem...
hope can help you...
發表於 : 2004-09-10 17:58
由 t119_net
finially found the error
but i don't know how to change the problem... sorry...
also it sometimes happen only...
the main point is the new stock..name and desc...
hope some strong programer can help...
Re: [問題] Vault 無法更新股票總數及董事長名單
發表於 : 2006-01-21 23:06
由 心靈捕手
a97cck 寫:問題外掛：Vault1.0
參考連結：
http://phpbb-tw.net/phpbb/viewtopic.php?t=24523
使用版本：php BB 2.0.10
網站位置：
http://plk2a.freelinuxhost.com/BB/index.php
狀況描述：
I have installed it and when I buy a stock,it shows
無法更新股票總數及董事長名單
DEBUG MODE
SQL Error : 1064 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 'WHERE stock_id = 1' at line 4
UPDATE phpbb_vault_exchange SET stock_total = 30 - 0, chairman = WHERE stock_id = 1
Line : 419
File : /home/www/plk2a.freelinuxhost.com/BB/vault.php
補充：
Cash Mod ,watched list mod ,flash cash mod and Vault1.0
I am looking forward for the help.Thx
(抱歉! 自爆)
Re: [問題] Vault 無法更新股票總數及董事長名單
發表於 : 2006-01-23 10:57
由 心靈捕手
心靈捕手 寫:(抱歉! 自爆)
除了這個修正之外, 建議再做以下的修正:
#
#-----[ OPEN ]-----
#
vault.php
#
#-----[ FIND ]-----
#
代碼: 選擇全部
$tsql = "UPDATE " . VAULT_EXCHANGE_TABLE ."
SET stock_total = ".$items[$i]['stock_total']." - $prize,
chairman = ".$chairman['user_id']."
WHERE stock_id = ".$items[$i]['stock_id']; // 更新股票總數及董事長名單\r
#
#-----[ REPLACE WITH ]-----
#
代碼: 選擇全部
$tsql = "UPDATE " . VAULT_EXCHANGE_TABLE ."
SET stock_total = ".$items[$i]['stock_total']." - $prize,
chairman = ".$chairman['user_id']."
WHERE stock_id = ".$items[$i]['stock_id'].""; // 更新股票總數及董事長名單\r
#
#-----[ SAVE & CLOSE ]-----
#
#EoM
ps.
真正會出現
語法錯誤的原因, 應該是這裡才對!
