Search found 9 matches

by Vazze
Mon Mar 30, 2015 8:31 pm
Forum: [3.1.x] Support Forum
Topic: SQL error on Full search MySQL
Replies: 10
Views: 902

Re: SQL error on Full search MySQL

I've altered the tables as you suggested, i then try to run create the MySQL-index and still get. So I just deleted the current MySQL Index from ACP and tried to use the create index button and it did the same thing (error). These are the exact steps I used to re-create the Index. Delete any Indexe...
by Vazze
Mon Mar 30, 2015 3:17 pm
Forum: [3.1.x] Support Forum
Topic: SQL error on Full search MySQL
Replies: 10
Views: 902

Re: SQL error on Full search MySQL

SQL ERROR [ mysqli ] InnoDB presently supports one FULLTEXT index creation at a time [1795] SQL ALTER TABLE phpbb_posts MODIFY post_subject varchar(255) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL, ADD FULLTEXT (post_subject), MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL, ADD FULLTE...
by Vazze
Mon Mar 30, 2015 10:01 am
Forum: [3.1.x] Support Forum
Topic: SQL error on Full search MySQL
Replies: 10
Views: 902

Re: SQL error on Full search MySQL

I think that is the result of a bug in MySQL. For certain operations it drops all the indexes and then recreates them with a single statement and that triggers the error. That was supposed to be fixed in MySQL 5.6.8. I did not have this problem on my other host (with phpbb 3.0.11) and mysql Ver 14....
by Vazze
Mon Mar 30, 2015 8:22 am
Forum: [3.1.x] Support Forum
Topic: SQL error on Full search MySQL
Replies: 10
Views: 902

SQL error on Full search MySQL

Support Request Template What version of phpBB are you using? phpBB 3.1.3 What is your board's URL? http://forum.11433.net Who do you host your board with? Hetzner How did you install your board? I used the download package from phpBB.com What is the most recent action performed on your board? Upda...
by Vazze
Mon Mar 30, 2015 7:31 am
Forum: [3.1.x] Support Forum
Topic: Your installed version is 3.1.0-dev?
Replies: 6
Views: 362

Re: Your installed version is 3.1.0-dev?

I did a re-install instead. Deleted database and all files downloaded 3.1.3 again re-installed files without images, files, styles and config.php transfered the old images, files, styles and config.php to the directory ran the /update_database.php instead of the CLI-one. Monitored the MySQL-database...
by Vazze
Sun Mar 29, 2015 9:29 am
Forum: [3.1.x] Support Forum
Topic: Your installed version is 3.1.0-dev?
Replies: 6
Views: 362

Re: Your installed version is 3.1.0-dev?

Update: Ran the update_db again (2h project) Get this in admin log: Vazze xx.xx.xxx.xx Sun Mar 29, 2015 07:29 Updated phpBB from version 3.1.0-dev to version 3.1.3 Its still say: Board version: 3.1.0-dev [ Re-Check version ] in ACP-Info. More update: Downloaded the modission_reset.php file, when i r...
by Vazze
Sun Mar 29, 2015 8:38 am
Forum: [3.1.x] Support Forum
Topic: Your installed version is 3.1.0-dev?
Replies: 6
Views: 362

Re: Your installed version is 3.1.0-dev?

Oyabun1 wrote:Which version are you upgrading from?
3.0.9

Edit: Sorry 3.0.11
by Vazze
Sun Mar 29, 2015 7:46 am
Forum: [3.1.x] Support Forum
Topic: Your installed version is 3.1.0-dev?
Replies: 6
Views: 362

Your installed version is 3.1.0-dev?

Hello fellow members of the forum. I followed the guide from here https://www.phpbb.com/support/docs/en/3.1/ug/upgradeguide/upgrade3/ and downloaded the 3.1.3 (complete package) and saved the config and the images, files and store folders. Deleted the rest. since i've run a board with about 1.5 mill...
by Vazze
Sat Sep 08, 2012 4:28 pm
Forum: [3.0.x] Support Forum
Topic: View latest post is behaving strangely.
Replies: 2
Views: 166

View latest post is behaving strangely.

Hi. Im experience abit of a problem with the function of "View latest post" in threads. Sometimes it doesnt go to the latest post and instead goes to the first post in the thread. I cant put my finger on whats happened, but it occured when i move the Forum from one host to another host, i've synced ...

Go to advanced search