Search found 67 matches

by jmpoure
Wed Mar 12, 2008 10:30 pm
Forum: [3.0/Olympus] Discussion
Topic: PhpBB 3.0 cookie management
Replies: 2
Views: 4817

Re: PhpBB 3.0 cookie management

Thanks. I already have this value in code. Are you sure this is an SVN fix?
by jmpoure
Wed Mar 12, 2008 6:22 pm
Forum: [3.0/Olympus] Discussion
Topic: Urgent : truncate sessions while changing cookies
Replies: 1
Views: 2050

Urgent : truncate sessions while changing cookies

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...
by jmpoure
Tue Mar 11, 2008 2:31 pm
Forum: [3.0/Olympus] Discussion
Topic: PhpBB 3.0 cookie management
Replies: 2
Views: 4817

PhpBB 3.0 cookie management

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...
by jmpoure
Fri Jan 11, 2008 9:13 am
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 49464

Re: SQL optimisation

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...
by jmpoure
Thu Jan 10, 2008 7:54 pm
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 117318

Re: PostgreSQL Fulltext Search

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_sort_join $sql_time ORDER...
by jmpoure
Thu Jan 10, 2008 5:17 pm
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 49464

Re: SQL optimisation

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...
by jmpoure
Thu Jan 10, 2008 4:57 pm
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 117318

Re: PostgreSQL Fulltext Search

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

Code: Select all

Erreur Générale
SQL ERROR [ postgres ]

ERREUR: La colonne « t.topic_last_post_time » doit apparaître dans la clause GROUP BY ou doit être utilisé dans une fonction d'aggrégat []

I will report later on.
by jmpoure
Thu Jan 10, 2008 7:02 am
Forum: [3.0/Olympus] Discussion
Topic: SQL optimisation
Replies: 70
Views: 49464

Re: SQL optimisation

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...
by jmpoure
Thu Jan 10, 2008 6:37 am
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 117318

Re: PostgreSQL Fulltext Search

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...
by jmpoure
Wed Jan 09, 2008 7:50 pm
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 117318

Re: PostgreSQL Fulltext Search

I could basically install your patch, thanks.
But some problems exist on non-C databases, when using locales:

Code: Select all

SQL ERROR [ postgres ]
ERREUR: could not find tsearch config by locale []
I am trying to install the French dictionary and will get back.