trying to moderate threads..error

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Suggested Hosts
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
rbrtgrmn
Registered User
Posts: 17
Joined: Thu Sep 17, 2015 4:28 am

trying to moderate threads..error

Post by rbrtgrmn » Fri Sep 18, 2015 4:13 pm

I tried to move a post to another topic today as admin. I received the following error.

Code: Select all

General Error
SQL ERROR [ mysqli ]

BIGINT UNSIGNED value is out of range in '(`narrator_flux`.`phpbb_forums`.`forum_posts_approved` - 1)' [1690]

SQL

UPDATE phpbb_forums SET forum_posts_approved = forum_posts_approved - 1, forum_topics_approved = forum_topics_approved - 1 WHERE forum_id = 4

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/mcp/mcp_main.php
LINE: 663
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/mcp/mcp_main.php
LINE: 96
CALL: mcp_move_topic()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: mcp_main->main()

FILE: [ROOT]/includes/functions_module.php
LINE: 998
CALL: p_master->load_active()

FILE: [ROOT]/mcp.php
LINE: 189
CALL: p_master->load()

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: trying to moderate threads..error

Post by Oyabun1 » Fri Sep 18, 2015 9:49 pm

Please fill out the Support Request Template and post it back here to enable us to assist you better.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

rbrtgrmn
Registered User
Posts: 17
Joined: Thu Sep 17, 2015 4:28 am

Re: trying to moderate threads..error

Post by rbrtgrmn » Sat Sep 19, 2015 1:25 am

Support Request Template
What version of phpBB are you using? phpBB 3.1.6
What is your board's URL? http://Baalt.net
Who do you host your board with? Arvixe
How did you install your board? I used a tool provided by my host
What is the most recent action performed on your board? Conversion from another software
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What board software did you convert from? MyBB
What extensions do you have installed? Announcements on index 1.0.1
Board3 Portal 2.1.0-rc2
Inline images in attachment 1.0.0
Site logo
What styles do you currently have installed? prosilver, Black
What language(s) is your board currently using? english
Which database type/version are you using? MariaDB
What is your level of experience? New to phpBB but not PHP
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? converted from mybb
installed the above extensions
installed a few styles BLACK
Please describe your problem. I am trying to MOVE a topic from one forum to another and I get the error below.

Code: Select all

General Error
SQL ERROR [ mysqli ]

BIGINT UNSIGNED value is out of range in '(`narrator_flux`.`phpbb_forums`.`forum_posts_approved` - 1)' [1690]

SQL

UPDATE phpbb_forums SET forum_posts_approved = forum_posts_approved - 1, forum_topics_approved = forum_topics_approved - 1 WHERE forum_id = 4

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/mcp/mcp_main.php
LINE: 663
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/mcp/mcp_main.php
LINE: 96
CALL: mcp_move_topic()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: mcp_main->main()

FILE: [ROOT]/includes/functions_module.php
LINE: 998
CALL: p_master->load_active()

FILE: [ROOT]/mcp.php
LINE: 189
CALL: p_master->load()
Generated by SRT Generator

rbrtgrmn
Registered User
Posts: 17
Joined: Thu Sep 17, 2015 4:28 am

Re: trying to moderate threads..error

Post by rbrtgrmn » Thu Sep 24, 2015 3:48 am

I have not heard anything on this issue? Did I forget to do something to get some help? :roll:

my new site address is baalt.org/flux.. old server crashed and I copied database over to new host..

same problem.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21435
Joined: Fri Aug 29, 2008 9:49 am
Location: Not watching cricket

Re: trying to moderate threads..error

Post by Mick » Thu Sep 24, 2015 8:02 am

rbrtgrmn wrote:How did you install your board? I used a tool provided by my host
This isn't the best route to go, hosts use software not written by us and we can't always help as we didn't write the software. Host installs are notorious for causing issues and often the host can't fix the problems they cause, have a search here, there are hundreds of cases. You should always use the download package from here for installations and upgrade/updates.
rbrtgrmn wrote:What is the most recent action performed on your board? Conversion from another software
How did you convert, did you do it yourself or did the host do it? Has everything been working ok since the conversion until this problem arose?

Try disabling all your extensions and changing the style back to prosilver and see if the problem persists.

PS: There are no threads in phpBB
"The more connected we get the more alone we become" - Kyle Broflovski

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: trying to moderate threads..error

Post by Oyabun1 » Thu Sep 24, 2015 8:47 am

rbrtgrmn wrote:What is your board's URL? http://Baalt.net
There doesn't seem to be anything there? Assuming that is a DNS propagation issue.

It may be that the convertor hasn't calculated the forum_posts_approved value for each forum. Resynchronising each of the forums will probably fix that.
ACP > FORUMS > Manage forums > forum name > Image
It is best to start at the lowest level and work up so. for example, do sub forums before forums.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21435
Joined: Fri Aug 29, 2008 9:49 am
Location: Not watching cricket

Re: trying to moderate threads..error

Post by Mick » Thu Sep 24, 2015 8:56 am

rbrtgrmn wrote:my new site address is baalt.org/flux..
"The more connected we get the more alone we become" - Kyle Broflovski

rbrtgrmn
Registered User
Posts: 17
Joined: Thu Sep 17, 2015 4:28 am

Re: trying to moderate threads..error

Post by rbrtgrmn » Thu Sep 24, 2015 7:36 pm

The resynching worked....thank you so much.

Onto my next issue.

Locked

Return to “[3.1.x] Support Forum”