Example Forum

Hi,

I downloaded the example forum to watch it and learn some stuff about TBS, but i don't understand how i'm supposed to make the db connection... I know how to make a regular connection but i have no clue on how it's supposed to be done here.

I'm kinda new to PHP so, thx for any help.

Ok, i fixed the db connection but now i get an error when creating the tables:

MySQL message: 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 'FULLTEXT KEY search (msg_subject,msg_body) ) TYPE=MyISAM' at l

Hi Radeon, skrol29

I just came across this issue and decided to investigate. I am not really an expert, so I hope this is all ok.

I think you can fix this issue yourself by simple modification of the "forum_install.php" file. In the function m_InitPatch you can find the SQL statement "CREATE TABLE t_forum_message". I noticed that the line "KEY th_id (thr_id)" did not have a comma at the end. Add the comma, save - then delete the partially built tables in the database, and run the install again.

However there is another issue. From memory, "cat_notif_url field was missing" popped up. So I just added:

  cat_notif_url text NOT NULL,

to the CREATE TABLE t_forum_category SQL.

This seemed to get rid of the problems, and I could establish the tables OK.

Finally I think this issue just applied to me, but when the mail notification was sent to admin, norton reported to me about "Bare LFs in SMTP" (see http://cr.yp.to/docs/smtplf.html for info). I looked in "index.php", and what I did was to comment out line 444 in function m_Email, i.e.

$message = str_replace("\r\n","\n",$message) ;

and I could send out the mail (& get it).

I hope this helps.

I think if it wasn't for skrol29's excellent diagnostics reported in the database install phase, I probably wouldn't have bothered, but it really helped me, so I say sincere thanks again to skrol for his excellent example.

Regards

Michael.

Hi,

I've fixed the 3 problems. New version 1.27 is available at the download page. Very thank you to both of you.

For the "Bare LFs in SMTP" message, i've put a tunable variable at the beginning of the index.php file. This parameter depends of the OS and the SMTP