Development Discussion Board

Thanks. I already have this value in code. Are you sure this is an SVN fix?

Dear friends, My forum (3000 users, 400.000 posts) got hacked after I changed cookie name and path. Someone became admin and gave admin rights to all users. I had no idea of PhpBB internals and did not know that I had to truncate (drop all records) in the session tables. Could it become an automatic...

Dear all, I am a real PhpBB 3.0 fan and I have to report a serious issue with sessions / cookie management. Phpbb 3.0 has been running fine during three months. Suddently users complained that PhpBB was frequently disconnecting. Then I modified cookie name and path in PhpBB admin panel. I seached co...

I agree that SQL queries should run on all databases. But to make it simple, database theory is common to ALL databases, including MySQL. Database theory teaches us that a LEFT JOIN is always faster than an INNER JOIN. Why? Because building an INNER JOIN requires a 2D array and several steps to ensu...

fulltext_postgressearch.php should be, line 590 and below $sql = "SELECT t.topic_id FROM " . $sql_sort_table . TOPICS_TABLE . ' t '. " LEFT JOIN " . POSTS_TABLE . " p ON t.topic_id = p.topic_id WHERE $sql_author $sql_topic_id $sql_firstpost $m_approve_fid_sql $sql_fora $sql_...

Another thing I was wondering: why isn't the session table stored in memory? It looks like (although I'm not certain) it's the only table to be continuosly rewritten, it's little, and if data gets lost is not a big problem. Because it would require to share data between PHP processes, which is an e...

Small bug : when clicking on "View your messages":

I will report later on.

MySQL is not a standard database and has many inconsistencies. Consider for example the existance of InnoDB tables and non-InnoDB tables. You cannot really garantee transactions in MySQL! In your exmaple, a 0,9% difference in speed does not matter. It probably means that MySQL internal code for INNE...

Okay, problems resolved. Phpbb 3.0 database is UTF-8 So there should be a dictionnary installed. In phpBB 3.0 code, there should be a test whether tsearch2 dictionary is installed for the current locale. I downloaded dictionnaries on tseach2 homepage. You should only install UTF-8 dictionnaries. Ada...

I could basically install your patch, thanks.
But some problems exist on non-C databases, when using locales:
I am trying to install the French dictionary and will get back.