Search found 12 matches

by cz_mawa
Wed Apr 10, 2019 4:10 pm
Forum: [3.2.x] Support Forum
Topic: MySQL SELECT last long time on new server
Replies: 10
Views: 434

Re: MySQL SELECT last long time on new server

JoshyPHP wrote:
Wed Apr 10, 2019 1:55 am
My money is this: you disabled indexes to import your backup and you didn't re-enable them.
I performed standard mysql dump from old server using mysql workbench, and used same version of mysql workbench to import it to new server. No special options.
by cz_mawa
Tue Apr 09, 2019 8:04 pm
Forum: [3.2.x] Support Forum
Topic: MySQL SELECT last long time on new server
Replies: 10
Views: 434

Re: MySQL SELECT last long time on new server

Well if 8.x branch of MySQL is not compatible with phpBB, it should be stated somewhere. Right now on the phpbb.com webpage is as required MySQL version written

Code: Select all

MySQL 3.23 or above (MySQLi supported)
. Not a single word about no compatibility with 8.x branch.
by cz_mawa
Tue Apr 09, 2019 11:54 am
Forum: [3.2.x] Support Forum
Topic: MySQL SELECT last long time on new server
Replies: 10
Views: 434

Re: MySQL SELECT last long time on new server

So, I: - compared every table data, columns, rows, indexes between old and new database. I didnt found any single difference. - installed mysql 8.0.15 on different machine and tried it there - just in case there is something wrong on the new server. With no luck. So as last try, I downloaded current...
by cz_mawa
Mon Apr 08, 2019 8:02 pm
Forum: [3.2.x] Support Forum
Topic: MySQL SELECT last long time on new server
Replies: 10
Views: 434

Re: MySQL SELECT last long time on new server

Hi, so I should check tables phpbb_acl_groups, phpbb_user_group, phpbb_groups, phpbb_acl_roles_data and phpbb_acl_options, is that correct ? Also, what exactly should that part of code do ? Maybe if it is nothing important I could comment it for now and move the phpBB to that new server, and solve t...
by cz_mawa
Mon Apr 08, 2019 3:25 pm
Forum: [3.2.x] Support Forum
Topic: MySQL SELECT last long time on new server
Replies: 10
Views: 434

MySQL SELECT last long time on new server

I'm setting up a new server, and want to move existing phpBB installation there. Everything went OK, except one SELECT is in SLOW log and eats CPU forever. I am not DB specialist, so I am lost. Old server - Win2008 R2, MySQL 5.7.24, php 5.6.39, single i7 Quad Core CPU, 24GB RAM New Server - Win2016,...
by cz_mawa
Mon Mar 06, 2017 2:39 pm
Forum: Custom BBCode Development and Requests
Topic: Youtube bbcode delete last letter in link
Replies: 3
Views: 738

Re: Youtube bbcode delete last letter in link

I tried http, https and identifier1 with no success... :(

Any idea whats wrong ?
by cz_mawa
Sat Mar 04, 2017 8:24 pm
Forum: Custom BBCode Development and Requests
Topic: Youtube bbcode delete last letter in link
Replies: 3
Views: 738

Youtube bbcode delete last letter in link

Hello guys, after upgrading from 3.0.14 to 3.2 we have strange problem with youtube bbcodes. All old youtube links miss last letter. In example <iframe id="ytplayer" width="560" height="345" src="https://www.youtube.com/embed/BV8MGY-NoE" frameborder="0" allowfullscreen="true"></iframe> This is html ...
by cz_mawa
Fri Feb 17, 2017 2:04 pm
Forum: [3.2.x] Support Forum
Topic: General Error: in file driver.php on line 996 when upgrading
Replies: 9
Views: 1026

Re: General Error: in file driver.php on line 996 when upgrading

As I understand it, the problem is in this function public function convert_user_field_to_custom_field($start) { $insert_buffer = new \phpbb\db\sql_insert_buffer($this->db, $this->table_prefix . 'profile_fields_data'); $limit = 250; $converted_users = 0; $start = $start ?: 0; $sql = 'SELECT user_id,...
by cz_mawa
Fri Feb 17, 2017 11:53 am
Forum: [3.2.x] Support Forum
Topic: General Error: in file driver.php on line 996 when upgrading
Replies: 9
Views: 1026

General Error: in file driver.php on line 996 when upgrading

Support Request Template What version of phpBB are you using? phpBB 3.2.0 What is your board's URL? http://www.alfisti.cz/forum/index.php Who do you host your board with? myself How did you install your board? I used the download package from phpBB.com What is the most recent action performed on yo...
by cz_mawa
Tue Jun 30, 2015 7:41 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: Viewtopic width too big with external pictures
Replies: 1
Views: 269

Viewtopic width too big with external pictures

Hello everybody, I have recently become an admin of one old phpBB installation (5 years without any update, 3.0.6 version or so). Running with Avalon Blue template...of course first thing to do was to update it to current 3.0.14. Everything went well, i have repaired many bugs in the Avalon template...

Go to advanced search