SQL ERROR [ mysqli ] repetitive !! need help plz

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
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
BF79
Registered User
Posts: 256
Joined: Fri Feb 13, 2015 1:28 pm

SQL ERROR [ mysqli ] repetitive !! need help plz

Post by BF79 » Sat Jan 06, 2018 4:21 pm

I had error yesterday without touching or changing something in my forum.. I created ticket to support host server..
they fixed my forum.. but he sent me this msg
Database repaired. You should consider upgrading your VPS plan, So that your site has more RAM to work on, there by giving less issues and errors.
is he right ??

here error that I had yesterday

Code: Select all

 General Error
    SQL ERROR [ mysqli ]

    Table 'phpbb_sessions' is marked as crashed and should be repaired [1194]

    SQL

    SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM phpbb_sessions s WHERE s.session_time >= 1515189360 AND s.session_user_id <> 1

    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/functions.php
    LINE: 4254
    CALL: phpbb\db\driver\factory->sql_query()

    FILE: [ROOT]/includes/functions.php
    LINE: 5054
    CALL: obtain_users_online()

    FILE: [ROOT]/index.php
    LINE: 234
    CALL: page_header()
and this error the first january

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table './ftsiempr_bb318/phpbb_sessions' is marked as crashed and should be repaired [145]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists
thanks guys for help

User avatar
Lumpy Burgertushie
Registered User
Posts: 66320
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: SQL ERROR [ mysqli ] repetitive !! need help plz

Post by Lumpy Burgertushie » Sat Jan 06, 2018 4:36 pm

how big is your board? how many posts, members, members online at a time etc

are you already on a VPS or are they just trying to sell you one?


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

BF79
Registered User
Posts: 256
Joined: Fri Feb 13, 2015 1:28 pm

Re: SQL ERROR [ mysqli ] repetitive !! need help plz

Post by BF79 » Sat Jan 06, 2018 4:55 pm

thanks for reply ! I m already in vps

Quad Core Xeon E3-1230 (1 Core)
512 MB RAM Guaranteed
1024 MB RAM Burstable
30 GB Disk Space [RAID 1]
1.5 TB Bandwidth
1 Gbps Port
1 IP Dedicated
SolusVM Control Panel


I think not too much visit !!
In total there are 21 users online :: 2 registered, 0 hidden and 19 guests (based on users active over the past 5 minutes)
66.jpg
w1.jpg
w2.jpg
w3.jpg

BF79
Registered User
Posts: 256
Joined: Fri Feb 13, 2015 1:28 pm

Re: SQL ERROR [ mysqli ] repetitive !! need help plz

Post by BF79 » Sat Jan 06, 2018 4:56 pm

those anonymous who want to login arent members !! bruteforce ?

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69092
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: SQL ERROR [ mysqli ] repetitive !! need help plz

Post by KevC » Sat Jan 06, 2018 5:05 pm

Why are you on a VPS with such a small board? You could easily be on shared hosting and save a fortune.

Everyone is anonymous until they log in.
Some of those look like spambot-type usernames.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

BF79
Registered User
Posts: 256
Joined: Fri Feb 13, 2015 1:28 pm

Re: SQL ERROR [ mysqli ] repetitive !! need help plz

Post by BF79 » Sat Jan 06, 2018 5:58 pm

KevC wrote:
Sat Jan 06, 2018 5:05 pm
Why are you on a VPS with such a small board? You could easily be on shared hosting and save a fortune.

Everyone is anonymous until they log in.
Some of those look like spambot-type usernames.
thank you..
I got many times this error last year the reason why they suggest to me to upgrade to small vps

Image

but now I haven't this error

User avatar
david63
Registered User
Posts: 16162
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: SQL ERROR [ mysqli ] repetitive !! need help plz

Post by david63 » Sat Jan 06, 2018 6:46 pm

I would suggest that you find a new host - one that knows what they are doing
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
Lumpy Burgertushie
Registered User
Posts: 66320
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: SQL ERROR [ mysqli ] repetitive !! need help plz

Post by Lumpy Burgertushie » Sat Jan 06, 2018 7:58 pm

I agree with david except that I think they know what they are doing. they are trying to rip you off and get you to upgrade to a bigger/more expensive plan.

any standard shared hosting should be able to handle a board of that size with that traffic and the vps setup you have now certainly should be able to.
if the database is crashing then it means there is something wrong with the database server settings and that is all on their end.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

BF79
Registered User
Posts: 256
Joined: Fri Feb 13, 2015 1:28 pm

Re: SQL ERROR [ mysqli ] repetitive !! need help plz

Post by BF79 » Sat Jan 06, 2018 8:10 pm

thank you my friends ! :)

Locked

Return to “[3.1.x] Support Forum”