Search found 67 matches
- Wed Mar 12, 2008 10:30 pm
- Forum: [3.0/Olympus] Discussion
- Topic: PhpBB 3.0 cookie management
- Replies: 2
- Views: 6440
Re: PhpBB 3.0 cookie management
Thanks. I already have this value in code. Are you sure this is an SVN fix?
- Wed Mar 12, 2008 6:22 pm
- Forum: [3.0/Olympus] Discussion
- Topic: Urgent : truncate sessions while changing cookies
- Replies: 1
- Views: 3005
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...
- Tue Mar 11, 2008 2:31 pm
- Forum: [3.0/Olympus] Discussion
- Topic: PhpBB 3.0 cookie management
- Replies: 2
- Views: 6440
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...
- Fri Jan 11, 2008 9:13 am
- Forum: [3.0/Olympus] Discussion
- Topic: SQL optimisation
- Replies: 70
- Views: 88671
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...
- Thu Jan 10, 2008 7:54 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 266926
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_...
- Thu Jan 10, 2008 5:17 pm
- Forum: [3.0/Olympus] Discussion
- Topic: SQL optimisation
- Replies: 70
- Views: 88671
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...
- Thu Jan 10, 2008 4:57 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 266926
Re: PostgreSQL Fulltext Search
Small bug : when clicking on "View your messages":
I will report later on.
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.
- Thu Jan 10, 2008 7:02 am
- Forum: [3.0/Olympus] Discussion
- Topic: SQL optimisation
- Replies: 70
- Views: 88671
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...
- Thu Jan 10, 2008 6:37 am
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 266926
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...
- Wed Jan 09, 2008 7:50 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 266926
Re: PostgreSQL Fulltext Search
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.
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 []