[問題] Vault 無法更新股票總數及董事長名單

文章由 **a97cck** » 2004-08-17 19:55

問題外掛：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

文章由 **a97cck** » 2004-08-19 10:10

Hey Please help!!!!!!!!!!!!!
please!

文章由 **問題狂** » 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"的原因呢?

文章由 **pc123** » 2004-08-19 13:02

不是.........
是程式的問題...
我之前也裝過.
好像有人有解決的辦法...我用過.....

文章由 **問題狂** » 2004-08-19 13:46

可是搜尋沒找到..

文章由 **t119_net** » 2004-09-07 12:40

change mode of root/cache/vault_config.php -> 666

i have similar error and now can run no problem...

good luck

文章由 **a97cck** » 2004-09-08 20:47

thx for your help but i am that ther is no improvment....

文章由 **t119_net** » 2004-09-09 12:58

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...

文章由 **t119_net** » 2004-09-10 17:58

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...

文章由 **心靈捕手** » 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

(抱歉! 自爆)

文章由 **心靈捕手** » 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.
真正會出現語法錯誤的原因, 應該是這裡才對!

竹貓星球

[問題] Vault 無法更新股票總數及董事長名單

[問題] Vault 無法更新股票總數及董事長名單

Re: [問題] Vault 無法更新股票總數及董事長名單

Re: [問題] Vault 無法更新股票總數及董事長名單

Re: [問題] Vault 無法更新股票總數及董事長名單