Favorites MOD Error!

Favorites MOD Error!

Posted by: garbun0629
Posted on: 2005-04-08 14:39:00

I recently installed the Favorites MOD on my php 2.0.13 forum and having some difficulties to operate it. I am not an expert in programming, so your big help would be appreciated.

From the install.txt, I did not create the SQL because I don't know what to do with that? So, I skipped this part:

#-----[ SQL ]------------------------------------------
#Where 'phpbb_' is your table prefix
CREATE TABLE `phpbb_favorites` (
`fav_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`topic_id` int(11) NOT NULL default '0',
PRIMARY KEY (`fav_id`)
)

When I was trying to click "Add to Favorites", I got this error message:

Could not insert data into favorites table
DEBUG MODE
SQL Error : 1146 Table 'abc.phpbb_favorites' doesn't exist
INSERT INTO phpbb_favorites (fav_id, user_id, topic_id) VALUES (NULL, '2','26')
Line : 60
File : favorites.php

Please reply my email because I really need this.

Thanks!

Re: Favorites MOD Error!

Posted by: matttail
Posted on: 2005-04-08 15:00:00

You can't just skip part of the instructions and expect it to work.

Here's a tutorial about how to do the cool SQL stuff required for your mod. from PHPBB site

Hopefully that will help explane what to do. You can log into the php My admin that the articles refer to by going to the host name that you creted with for the origional phpbb install.



-Matttail

Re: Favorites MOD Error!

Posted by: garbun0629
Posted on: 2005-04-08 21:52:00

Thanks!
Got it!

Tags: emailsql errornullphpbbauto incrementmoddefaultphperror messageskippedprefixdebugappreciatedtxtabc