Forum Hosting  

Go Back   Forum Hosting > IPB Support > IPB General Support

IPB General Support Post your questions here, no bug reports.


Reply
 
LinkBack Thread Tools Display Modes
Old 10-01-2007, 09:56 PM   #751 (permalink)
Member
 
masfonos's Avatar
 
Join Date: Sep 2007

Posts: 28
Rep Power: 0 masfonos is on a distinguished road
fTrader: (0)
fBuck$: 166
Bank: 0
Total fBuck$: 166

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

Quote:
Originally Posted by Kurisu View Post
IPB Bug Reports is the section you posted in. YOUR forum is a phpBB forum. Please repost in the correct section.
Quote:
Originally Posted by masfonos View Post
... I, along with about a hundred other people have posted this error in the phpBB support forum without a single response from the staff ...

....


Regardless, it's obviously not an IPB vs phpBB issue, it's an SQL/DB issue. Someone should fix it as this has been going on for the better part of a week on both types of forums and nobody, user, admin, staff, etc. seems to have the slightest idea of what is going on and the only communication channels are users reporting the problem with no help from anyone.
masfonos is offline   Reply With Quote
Old 10-30-2007, 10:07 AM   #752 (permalink)
Member
 
sknsdames's Avatar
 
Join Date: Sep 2007

Posts: 1
Rep Power: 0 sknsdames is on a distinguished road
fTrader: (0)
fBuck$: 28
Bank: 0
Total fBuck$: 28

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

Quote:
Originally Posted by Kurisu View Post
Please post in the proper section. Your forum is phpBB not IPB.


problem with

http://sknsdames.19.forumer.com

thanks..
voetbal@telenet.be
sknsdames is offline   Reply With Quote
Old 11-01-2007, 10:57 AM   #753 (permalink)
Member
 
CyberAzeze's Avatar
 
Join Date: Mar 2006

Posts: 2
Rep Power: 0 CyberAzeze is on a distinguished road
fTrader: (0)
fBuck$: 146
Bank: 0
Total fBuck$: 146

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

Hi,

My forum (http://adikbijak.3.forumer.com) is having mySQL Error as shown below. Please help.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

mySQL query error: SELECT p.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number,
m.signature, m.website,m.yahoo,m.integ_msg,m.title,m.hide_email,m.msnname, m.warn_level, m.warn_lastwarn,
g.g_id, g.g_title, g.g_icon, g.g_dohtml
FROM adikbijak_posts p
LEFT JOIN adikbijak_members m ON (p.author_id=m.id)
LEFT JOIN adikbijak_groups g ON (g.g_id=m.mgroup)

WHERE p.topic_id=420 and p.queued != 1
ORDER BY p.pid asc LIMIT 0, 10); //15

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '); //15' at line 10
mySQL error code:
Date: Thursday 01st of November 2007 11:44:11 AM
CyberAzeze is offline   Reply With Quote
Old 11-01-2007, 11:05 AM   #754 (permalink)
Active Forumer
 
atsw's Avatar
 
Join Date: Apr 2005

Posts: 598
Rep Power: 4 atsw is on a distinguished road
fTrader: (0)
fBuck$: 4,839
Bank: 0
Total fBuck$: 4,839

My Forumer
My Country:
Red face MySQL Database Error

Quote:
There appears to be an error with the Teen web Forum database.
You can try to refresh the page by clicking here, if this does not fix the error, you can contact the board administrator by clicking here

Error Returned

mySQL query error: SELECT p.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number,
m.signature, m.website,m.yahoo,m.integ_msg,m.title,m.hide_email,m.msnname, m.warn_level, m.warn_lastwarn,
g.g_id, g.g_title, g.g_icon, g.g_dohtml
FROM teenwebbg_posts p
LEFT JOIN teenwebbg_members m ON (p.author_id=m.id)
LEFT JOIN teenwebbg_groups g ON (g.g_id=m.mgroup)

WHERE p.topic_id=195 and p.queued != 1
ORDER BY p.pid asc LIMIT 0, 10); //25

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '); //25' at line 10
mySQL error code:
Date: Thursday 01st of November 2007 11:53:10 AM
Links to forums I visit that all have this problem:

http://teenwebbg.3.forumer.com/index.php?showtopic=195
http://fen4etata.3.forumer.com/index.php?showtopic=92
http://djmusicpro.3.forumer.com/inde...showtopic=1287

It seems this affects the whole server.
Attached Images
File Type: jpg 11.jpg (33.2 KB, 47 views)

Last edited by atsw; 11-01-2007 at 11:11 AM.
atsw is offline   Reply With Quote
Old 11-01-2007, 11:07 AM   #755 (permalink)
Member
 
sinkbean2's Avatar
 
Join Date: Nov 2007

Posts: 1
Rep Power: 0 sinkbean2 is on a distinguished road
fTrader: (0)
fBuck$: 72
Bank: 0
Total fBuck$: 72

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

I am having the same problems with my forum.

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '); //50' at line 10
mySQL error code:

http://thedixiepig.3.forumer.com

Can someone help me with this? I'm getting it on all posts, however if I do a member post history search, I can see the text fine.
sinkbean2 is offline   Reply With Quote
Old 11-01-2007, 11:08 AM   #756 (permalink)
Junior Forumer
 
crazyspaniel's Avatar
 
Join Date: May 2004

Posts: 62
Rep Power: 5 crazyspaniel is on a distinguished road
fTrader: (0)
fBuck$: 970
Bank: 0
Total fBuck$: 970

My Forumer
My Country:
Default Re: MySQL Database Error

my server 3 forum too
http://springthing.3.forumer.com
just adding to the frustration of server 3 members and their forum members
crazyspaniel is offline   Reply With Quote
Old 11-01-2007, 12:19 PM   #757 (permalink)
Member
 
Redditchfool's Avatar
 
Join Date: Oct 2006

Posts: 1
Rep Power: 0 Redditchfool is on a distinguished road
fTrader: (0)
fBuck$: 25
Bank: 0
Total fBuck$: 25

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

Getting exactly the same error!

http://redditch.3.forumer.com

It seems to be a thing with server 3.



Quote:
Originally Posted by sinkbean2 View Post
I am having the same problems with my forum.

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '); //50' at line 10
mySQL error code:

http://thedixiepig.3.forumer.com
Redditchfool is offline   Reply With Quote
Old 11-01-2007, 12:35 PM   #758 (permalink)
Active Forumer
 
atsw's Avatar
 
Join Date: Apr 2005

Posts: 598
Rep Power: 4 atsw is on a distinguished road
fTrader: (0)
fBuck$: 4,839
Bank: 0
Total fBuck$: 4,839

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

Here too, looks like the whole server 3 has this MySQL error.
atsw is offline   Reply With Quote
Old 11-01-2007, 12:48 PM   #759 (permalink)
Member
 
dizma's Avatar
 
Join Date: Oct 2006

Posts: 44
Rep Power: 0 dizma is on a distinguished road
fTrader: (0)
fBuck$: 291
Bank: 0
Total fBuck$: 291

My Forumer
My Country:
Default Re: MySQL Database Error

I am facing the same problem.

http://reformacija.3.forumer.com/
dizma is offline   Reply With Quote
Old 11-01-2007, 12:49 PM   #760 (permalink)
Member
 
Demiglot's Avatar
 
Join Date: Aug 2005

Posts: 15
Rep Power: 0 Demiglot is on a distinguished road
fTrader: (0)
fBuck$: 96
Bank: 0
Total fBuck$: 96

My Forumer
My Country:
Default Topics not viewable.

I'm able to view forums but not individual topics. When clicking on the topic title this error appears:

Quote:
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '); //20' at line 10
mySQL error code:
Date: Thursday 01st of November 2007 01:41:35 PM
My members have expressed growing frustration with Forumer because of the slow load times and down times we've experienced lately. I'd like to stay with your service. Please help.

http://adrp.3.forumer.com/
Demiglot is offline   Reply With Quote
Old 11-01-2007, 12:50 PM   #761 (permalink)
Junior Forumer
 
JACC's Avatar
 
Join Date: Mar 2006

Posts: 111
Rep Power: 3 JACC is on a distinguished road
fTrader: (0)
fBuck$: 784
Bank: 0
Total fBuck$: 784

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

i'm getting the same error, but only when i try to read the topics... i can use al the functions, except that... server #3
http://dishrealm.3.forumer.com/

Quote:
mySQL query error: SELECT p.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number,
m.signature, m.website,m.yahoo,m.integ_msg,m.title,m.hide_email,m.msnname, m.warn_level, m.warn_lastwarn,
g.g_id, g.g_title, g.g_icon, g.g_dohtml
FROM dishrealm_posts p
LEFT JOIN dishrealm_members m ON (p.author_id=m.id)
LEFT JOIN dishrealm_groups g ON (g.g_id=m.mgroup)

WHERE p.topic_id=18832 and p.queued != 1
ORDER BY p.pid asc LIMIT 0, 10); //25

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '); //25' at line 10
mySQL error code:
Date: Thursday 01st of November 2007 01:38:08 PM
JACC is offline   Reply With Quote
Old 11-01-2007, 12:50 PM   #762 (permalink)
Member
 
TheSultan's Avatar
 
Join Date: Nov 2006

Posts: 7
Rep Power: 0 TheSultan is on a distinguished road
fTrader: (0)
fBuck$: 57
Bank: 0
Total fBuck$: 57

My Forumer
My Country:
Default Re: MySQL Database Error

TheSultan is offline   Reply With Quote
Old 11-01-2007, 12:51 PM   #763 (permalink)
Member
 
Demiglot's Avatar
 
Join Date: Aug 2005

Posts: 15
Rep Power: 0 Demiglot is on a distinguished road
fTrader: (0)
fBuck$: 96
Bank: 0
Total fBuck$: 96

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

http://adrp.3.forumer.com/
Demiglot is offline   Reply With Quote
Old 11-01-2007, 12:59 PM   #764 (permalink)
Active Forumer
 
atsw's Avatar
 
Join Date: Apr 2005

Posts: 598
Rep Power: 4 atsw is on a distinguished road
fTrader: (0)
fBuck$: 4,839
Bank: 0
Total fBuck$: 4,839

My Forumer
My Country:
Default Re: MySQL Database Error

With all the problem this server gets, I'm surprised that it's even online... slow load, no load, no MySQL to connect to, no "sent items"... this server is just... Forumer should just unplug it and have it fixed for good of all the bugs and errors...
atsw is offline   Reply With Quote
Old 11-01-2007, 01:03 PM   #765 (permalink)
Member
 
uaestudents's Avatar
 
Join Date: Oct 2006

Posts: 26
Rep Power: 0 uaestudents is on a distinguished road
fTrader: (0)
fBuck$: 157
Bank: 0
Total fBuck$: 157

My Forumer
My Country:
Default Re: MySQL Database Error

same problem her

uaestudents.999.org
uaestudents is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql errors Again The Blindman IPB General Support 8 04-26-2006 11:55 AM
[resolved]*Mysql Errors? XIII IPB General Support 3 09-20-2004 01:08 PM
[resolved]*[being Worked On]*mysql Errors :( Daz IPB General Support 1 05-16-2004 12:47 PM
[resolved]*Mysql Errors? cmk2034 IPB General Support 0 12-31-1969 06:00 PM