I have a block with the latest reviews on my home page at www.tenchidomain.com
When you click on them they goto a page within the reviews module but there is no review and just a block saying it was posted december 21, 1969. the link which the home page point to ishttp://www.tenchidomain.com/modules/myReviews/detailfile.php?lid=3 . If you know what is wrong and can help plese let me know thanks.

Quote:
Hi vec777, it looks like the sql is not working propperly. Please select sql debug in XOOPS preferance and paste the resulst here.

Grotmis
Riaan
CraftsOnline

Queries
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '60d193dfc90e078b27b260d7e9de914c'
SELECT * FROM xoops_users WHERE uid=3
SELECT * FROM xoops_modules WHERE dirname = 'system'
SELECT * FROM xoops_modules WHERE dirname = 'system'
SELECT * FROM xoops_configcategory
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = 1 AND (gperm_groupid = 1 OR gperm_groupid = 2))
Total: 7 queries

Blocks
Total: 0 blocks

Execution Time
XOOPS took 0.13183379173279 seconds to load.


from admin page

Queries
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '60d193dfc90e078b27b260d7e9de914c'
SELECT * FROM xoops_users WHERE uid=3
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 3) ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 0, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 7
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,-1) AND b.bid IN (1,22,2,9,3,4,13,5,6,7,8,25,10,11,21,12,20,19,18,14,15,16,17,23,24,26,27,28,29,30,31,32,33,34,35,36,37,38,41,42,43,44,51,53,49,52,50) ORDER BY b.weight,b.bid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
SELECT * FROM xoops_modules WHERE (hasmain = 1 AND isactive = 1 AND weight > 0) ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = 1 AND (gperm_groupid = 1 OR gperm_groupid = 2))
SELECT gperm_itemid FROM xoops_group_permission WHERE gperm_name='myalbum_global' AND (gperm_groupid IN (1,2))
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_dummy.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_dummy.html') ORDER BY tpl_refid
SELECT storyid, title, published, expired, counter FROM xoops_stories WHERE published < 1083580269 AND published > 0 AND (expired = 0 OR expired > 1083580269) ORDER BY published DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'news_block_new.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'news_block_new.html') ORDER BY tpl_refid
SELECT * FROM xoops_xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC
SELECT * FROM xoops_xoopspoll_option WHERE poll_id=1 ORDER BY option_id
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'xoopspoll_block_poll.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'xoopspoll_block_poll.html') ORDER BY tpl_refid
SELECT mid FROM xoops_modules WHERE dirname='piCal'
SELECT conf_name,conf_value FROM xoops_config WHERE conf_modid=8
SELECT * FROM xoops_groups
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_dummy.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_dummy.html') ORDER BY tpl_refid
SELECT lid, cid, title, date, hits, votes, rating FROM xoops_myReviews_downloads WHERE status>0 ORDER BY date DESC LIMIT 0, 10
SELECT title, cid FROM xoops_myReviews_cat WHERE cid=1
SELECT title, cid FROM xoops_myReviews_cat WHERE cid=1
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_dummy.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_dummy.html') ORDER BY tpl_refid
SELECT groups, link, title, target FROM xoops_multimenu01 WHERE hide=0 ORDER BY weight ASC
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = 0 AND to_userid = 3)
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_online WHERE online_uid=3
INSERT INTO xoops_online (online_uid, online_uname, online_updated, online_ip, online_module) VALUES (3, 'vec777', 1083580270, '24.209.88.183', 0)
SELECT * FROM xoops_online
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
Total: 46 queries

Blocks
Login: No Cache
Search: No Cache
Main Menu: No Cache
Custom Block (HTML): No Cache
Recent News: No Cache
Polls: No Cache
MiniCalendar: No Cache
Recent Reviews: No Cache
multiMenu 1: No Cache
User Menu: No Cache
Who's Online: No Cache
Total: 11 blocks

Execution Time
XOOPS took 1.2594048976898 seconds to load.


from home page

SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '60d193dfc90e078b27b260d7e9de914c'
SELECT * FROM xoops_users WHERE uid=3
SELECT * FROM xoops_modules WHERE dirname = 'myReviews'
SELECT * FROM xoops_config WHERE (conf_modid = 9) ORDER BY conf_order ASC
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 3) ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 0, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 7
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,9) AND b.bid IN (1,22,2,9,3,4,13,5,6,7,8,25,10,11,21,12,20,19,18,14,15,16,17,23,24,26,27,28,29,30,31,32,33,34,35,36,37,38,41,42,43,44,51,53,49,52,50) ORDER BY b.weight,b.bid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
SELECT * FROM xoops_modules WHERE (hasmain = 1 AND isactive = 1 AND weight > 0) ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = 1 AND (gperm_groupid = 1 OR gperm_groupid = 2))
SELECT gperm_itemid FROM xoops_group_permission WHERE gperm_name='myalbum_global' AND (gperm_groupid IN (1,2))
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT groups, link, title, target FROM xoops_multimenu01 WHERE hide=0 ORDER BY weight ASC
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = 0 AND to_userid = 3)
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_online WHERE online_uid=3
UPDATE xoops_online SET online_updated=1083580326, online_module = 9 WHERE online_uid = 3
SELECT * FROM xoops_online
SELECT COUNT(*) FROM xoops_online WHERE online_module = 9
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT d.lid, d.cid, d.title, d.url, d.homepage, d.version, d.size, d.platform, d.price, d.logourl, d.status, d.date, d.hits, d.rating, d.votes, d.comments, t.description, k.review FROM xoops_myReviews_downloads d, xoops_myReviews_text t, xoops_myReviews_reviews k WHERE d.lid=3 AND d.lid=t.lid AND status>0
SELECT e.editorial FROM xoops_myReviews_editorials e WHERE e.lid=
Error number: 1064
Error message: You have an error in your SQL syntax near '' at line 1
SELECT pid, title FROM xoops_myReviews_cat WHERE cid=
Error number: 1064
Error message: You have an error in your SQL syntax near '' at line 1
SELECT * FROM xoops_smiles
SELECT cid FROM xoops_myReviews_downloads WHERE lid=
Error number: 1064
Error message: You have an error in your SQL syntax near '' at line 1
SELECT rid, ratingcat FROM xoops_myReviews_ratingcat WHERE cid=
Error number: 1064
Error message: You have an error in your SQL syntax near '' at line 1
UPDATE xoops_myReviews_downloads SET hits=hits+1 WHERE lid= AND status>0
Error number: 1064
Error message: You have an error in your SQL syntax near 'AND status>0' at line 1
SELECT pid, title FROM xoops_myReviews_cat WHERE cid=
Error number: 1064
Error message: You have an error in your SQL syntax near '' at line 1
SELECT rating FROM xoops_myReviews_votedata WHERE lid =
Error number: 1064
Error message: You have an error in your SQL syntax near '' at line 1
SELECT COUNT(*) FROM xoops_myReviews_votedata WHERE lid=
Error number: 1064
Error message: You have an error in your SQL syntax near '' at line 1
SELECT reviewid, reviewuser, review, reviewhostname, reviewtimestamp FROM xoops_myReviews_reviews WHERE lid = ORDER BY reviewtimestamp ASC LIMIT 0, 5
Error number: 1064
Error message: You have an error in your SQL syntax near 'ORDER BY reviewtimestamp ASC LIMIT 0, 5' at line 1
Total: 41 queries

Blocks
Login: No Cache
Search: No Cache
Main Menu: No Cache
multiMenu 1: No Cache
User Menu: No Cache
Who's Online: No Cache
Total: 6 blocks

Execution Time
XOOPS took 0.68666195869446 seconds to load.



from reviews page after clicking the link

Quote:
Hi vec777, it looks like the id is not being sent with the get method to the detail form and that will show blanks. I will see if I can change the code to use post mothods where the get variable is blank. I think this will solve your problem. I am not sure why some setups do not allow post var passing. I will log this bug in the module dev forge and you can track it there.

Grotmis
Riaan

Thanks for the help, I'm new with this so what exactly do i need to do on my end to fix the problem?

I replaced the bit of code, but unless there is more than one instance i need to replace it did not fix my problem ;-;

Quote:
Hi vec777, it must be some setting either in your web server or in the php setup that is affecting the post varaibles, I will do some digging on this. What webserver and version of php are you using? Are you running a firewall?

Grotmis
Riaan

i know it is apache weserver with php 4.x installed