Reviews Module

Worker Joined: Dec 21, 2004 Posts: 116

I cannot insert reviews in my Review module.
I write, I click the Preview button then I confirm the insertion, I get no errors... but no one Review is in the database and I return to the Reviews main index without passing in the confirmed insertion page.
Shocked

My reviews tables are:

Code:




-- 


-- Struttura della tabella `nuke_reviews` 


-- 





CREATE TABLE `nuke_reviews` ( 


`id` int(10) NOT NULL auto_increment, 


`date` date NOT NULL default '0000-00-00', 


`title` varchar(150) NOT NULL default '', 


`text` text NOT NULL, 


`reviewer` varchar(20) default NULL, 


`email` varchar(60) default NULL, 


`score` int(10) NOT NULL default '0', 


`cover` varchar(100) NOT NULL default '', 


`url` varchar(100) NOT NULL default '', 


`url_title` varchar(50) NOT NULL default '', 


`hits` int(10) NOT NULL default '0', 


`rlanguage` varchar(30) NOT NULL default '', 


PRIMARY KEY (`id`) 


) TYPE=MyISAM AUTO_INCREMENT=1 ; 





-- 


-- Dump dei dati per la tabella `nuke_reviews` 


-- 








-- -------------------------------------------------------- 





-- 


-- Struttura della tabella `nuke_reviews_add` 


-- 





CREATE TABLE `nuke_reviews_add` ( 


`id` int(10) NOT NULL auto_increment, 


`date` date default NULL, 


`title` varchar(150) NOT NULL default '', 


`text` text NOT NULL, 


`reviewer` varchar(20) NOT NULL default '', 


`email` varchar(60) default NULL, 


`score` int(10) NOT NULL default '0', 


`url` varchar(100) NOT NULL default '', 


`url_title` varchar(50) NOT NULL default '', 


`rlanguage` varchar(30) NOT NULL default '', 


PRIMARY KEY (`id`) 


) TYPE=MyISAM AUTO_INCREMENT=1 ; 





-- 


-- Dump dei dati per la tabella `nuke_reviews_add` 


-- 








-- -------------------------------------------------------- 





-- 


-- Struttura della tabella `nuke_reviews_comments` 


-- 





CREATE TABLE `nuke_reviews_comments` ( 


`cid` int(10) NOT NULL auto_increment, 


`rid` int(10) NOT NULL default '0', 


`userid` varchar(25) NOT NULL default '', 


`date` datetime default NULL, 


`comments` text, 


`score` int(10) NOT NULL default '0', 


PRIMARY KEY (`cid`), 


KEY `rid` (`rid`), 


KEY `userid` (`userid`) 


) TYPE=MyISAM AUTO_INCREMENT=1 ; 





-- 


-- Dump dei dati per la tabella `nuke_reviews_comments` 


-- 








-- -------------------------------------------------------- 





-- 


-- Struttura della tabella `nuke_reviews_comments_moderated` 


-- 





CREATE TABLE `nuke_reviews_comments_moderated` ( 


`cid` int(10) NOT NULL auto_increment, 


`rid` int(10) NOT NULL default '0', 


`userid` varchar(25) NOT NULL default '', 


`date` datetime default NULL, 


`comments` text, 


`score` int(10) NOT NULL default '0', 


PRIMARY KEY (`cid`), 


KEY `rid` (`rid`), 


KEY `userid` (`userid`) 


) TYPE=MyISAM AUTO_INCREMENT=1 ; 





-- 


-- Dump dei dati per la tabella `nuke_reviews_comments_moderated` 


-- 








-- -------------------------------------------------------- 





-- 


-- Struttura della tabella `nuke_reviews_main` 


-- 





CREATE TABLE `nuke_reviews_main` ( 


`title` varchar(100) default NULL, 


`description` text 


) TYPE=MyISAM; 





-- 


-- Dump dei dati per la tabella `nuke_reviews_main` 


-- 





INSERT INTO `nuke_reviews_main` VALUES ('Reviews Section Title', 'Reviews Section Long Description');

Sells PC To Pay For Divorce Joined: Posts: 5661

do you have set ...display errors to ON in your config..if not set it on and see if it shows any errors..

Posted: Mon Oct 10, 2005 7:29 am

In my local installation I have set error_display on but no error is returned.

The strange is I can write it, I can preview it (so the variables are passed right) but when I click on the YES button that have to call

Code:

send_review($date, $title, $text, $reviewer, $email, $score, $cover, $url, $url_title, $hits, $id, $rlanguage);

The module return to the main index.

Posted: Mon Oct 10, 2005 7:37 am

whats the nuke version ?

Posted: Mon Oct 10, 2005 8:42 am

7.8 patched 3.1

Posted: Mon Oct 10, 2005 9:21 am

is it the standard version that comes with phpnuke ?

Posted: Mon Oct 10, 2005 9:26 am

i dont know if thats the case but

Code:

KEY `id` (`id`)

seems te be missing in your table.

Posted: Mon Oct 10, 2005 11:00 am

If you intend in nuke_reviews table I added but the error don't go away...

Quote:

is it the standard version that comes with phpnuke ?

Yes, I just extracted and inserted.

Posted: Mon Oct 10, 2005 11:02 am

i suggest you install the reviews module tables again...

Posted: Tue Oct 11, 2005 2:06 am

Just tried without any good results... someone has it function ?

I have modified some core file for nukesentinel and other mod, which files can influence the Reviews module ? Admin.php ? Mainfile ? Modules.php ?

Posted: Tue Oct 11, 2005 4:03 am

well....realy...if everything you use is standard but the reviews is not working then something is preventing it from working.
Just a thought......try it but with sentinel disabled for a few minutes...
just take out the includes code....anyway whatever....so that sentinel doesnt work....
Then see if the reviews will work again...
if not...
then its conflicting with something else.