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 11-01-2007, 01:27 PM   #766 (permalink)
Member
 
PaulReed's Avatar
 
Join Date: Oct 2006

Posts: 15
Rep Power: 0 PaulReed is on a distinguished road
fTrader: (0)
fBuck$: 10,093
Bank: 0
Total fBuck$: 10,093

My Forumer
My Country:
Default Re: MySQL Database Error

Same problem with my site, too.
PaulReed is offline   Reply With Quote
Old 11-01-2007, 01:38 PM   #767 (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,823
Bank: 0
Total fBuck$: 4,823

My Forumer
My Country:
Default Re: Topics not viewable.

Same here! Please fix!!!!
atsw is offline   Reply With Quote
Old 11-01-2007, 01:47 PM   #768 (permalink)
Member
 
MonnieFYFRE123's Avatar
 
Join Date: Mar 2007

Posts: 6
Rep Power: 0 MonnieFYFRE123 is on a distinguished road
fTrader: (0)
fBuck$: 106
Bank: 0
Total fBuck$: 106

My Forumer
My Country:
Default Re: MySQL Database Error

Please fix it!!! :'(

fyfre.3.forumer.com
MonnieFYFRE123 is offline   Reply With Quote
Old 11-01-2007, 01:58 PM   #769 (permalink)
Senior Forumer
 
Pandemix's Avatar
 
Join Date: Feb 2006

Location: En Jay
Posts: 1,739
Blog Entries: 1
Rep Power: 4 Pandemix will become famous soon enough
fTrader: (14)
fBuck$: 167
Bank: 1,244
Total fBuck$: 1,411

My Forumer
My Country:
Default Re: MySQL Database Error

Issue Escalated!

This issue has been escalated to our technicians and the admin was notified.
They will attend to the problem you reported in a timely manner.

Next time you request support, please follow these guidlines.

Thanks for choosing Forumer!

Pandemix
fSupport Staff

Pandemix is offline   Reply With Quote
Old 11-01-2007, 02:13 PM   #770 (permalink)
Admin
 
Limez's Avatar
 
Join Date: Dec 2003

Location: Forumer.com
Posts: 2,942
Blog Entries: 2
Rep Power: 10 Limez will become famous soon enough
fTrader: (4)
fBuck$: 2,803,307
Bank: 620
Total fBuck$: 2,803,928

My Forumer
My Country:
Default Re: MySQL Database Error

we're working on this.

FORUMER.com - Pioneering forum hosting since 2003. Why should you host with Forumer?

The Forumer network is powered by a robust cluster of 35 high-end servers.

Create your own forum NOW phpbb/IPB

phpBB3 is open to almost everyone


Forumer turns 4 YEARS OLD!!!


Free forum hosting < add me to your blog, get code here!
Limez is offline   Reply With Quote
Old 11-01-2007, 02:53 PM   #771 (permalink)
Active Forumer
 
LizAlmond1's Avatar
 
Join Date: Oct 2006

Posts: 281
Rep Power: 2 LizAlmond1 is on a distinguished road
fTrader: (0)
fBuck$: 739
Bank: 788
Total fBuck$: 1,527

My Forumer
My Country:
Unhappy Re: MySQL Database Error

Thank-you for working on this Limez i have the same problem.Looks a right mess on my forum with all the duplicate posts.
LizAlmond1 is offline   Reply With Quote
Old 11-01-2007, 02:54 PM   #772 (permalink)
Active Forumer
 
LizAlmond1's Avatar
 
Join Date: Oct 2006

Posts: 281
Rep Power: 2 LizAlmond1 is on a distinguished road
fTrader: (0)
fBuck$: 739
Bank: 788
Total fBuck$: 1,527

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

http://dollchitchat.3.forumer.com/
LizAlmond1 is offline   Reply With Quote
Old 11-01-2007, 02:56 PM   #773 (permalink)
fSupport Manager
 
Kurisu's Avatar
 
Join Date: Mar 2004
Tournaments Won: 1

Posts: 8,622
Blog Entries: 1
Rep Power: 10 Kurisu will become famous soon enoughKurisu will become famous soon enough
fTrader: (23)
fBuck$: 602
Bank: 238,099
Total fBuck$: 238,701

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

We are aware of the problem on s3. You do not need to post your forum url.

[http://www.tacticalassistance.co.uk/][http://proxcentral.info/][AJAX Domain Search][Cheap Web Hosting] fMods.com

Apply for fBuzz today!
"Attitude, your paint skills are godlike."- Stanky
Kurisu is offline   Reply With Quote
Old 11-01-2007, 03:48 PM   #774 (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,823
Bank: 0
Total fBuck$: 4,823

My Forumer
My Country:
Default Re: MySQL Database Error

Yay! Limez is here
Thanks Limez! Good luck with finding this error and fixing... btw, the forums on s3 were ULTRA slow and timing out during the past 3 weeks, prior to this error, could this error be the reason? Will the slow load also be fixed? Thanks *where is that hug smiley when u need it*
atsw is offline   Reply With Quote
Old 11-01-2007, 05:37 PM   #775 (permalink)
Member
 
Demiglot's Avatar
 
Join Date: Aug 2005

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

My Forumer
My Country:
Default Re: MySQL Database Error

Thanks for the fast reply. Looking forward to using your forums again soon!
Demiglot is offline   Reply With Quote
Old 11-01-2007, 06:21 PM   #776 (permalink)
Member
 
Demiglot's Avatar
 
Join Date: Aug 2005

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

My Forumer
My Country:
Default Re: MySQL Database Error

A message from one of my forum users:

Quote:
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
adrp_posts p <------------ HERE
LEFT JOIN
adrp_members m <------------ HERE
ON
(p.author_id=m.id)
LEFT JOIN
adrp_groups g <------------ AND HERE
ON
(g.g_id=m.mgroup)
WHERE
p.topic_id=902 and
p.queued != 1
ORDER BY
p.pid asc
LIMIT 0, 10
Hope that is helpful.
Demiglot is offline   Reply With Quote
Old 11-01-2007, 07:02 PM   #777 (permalink)
Member
 
Dave K's Avatar
 
Join Date: Jun 2007

Posts: 20
Rep Power: 0 Dave K is on a distinguished road
fTrader: (0)
fBuck$: 302
Bank: 0
Total fBuck$: 302

My Forumer
My Country:
Default Re: MySQL Database Error

Thanks for working on this and treating the matter with urgency. It's very much appreciated. It would be very helpful if we got a periodic update. Even something like an estimated time--I know it's very hard to be precise. I'd like to keep our members *******d to the extent I can.

Thanks!

--Dave
Dave K is offline   Reply With Quote
Old 11-01-2007, 07:13 PM   #778 (permalink)
Member
 
MotoTiller's Avatar
 
Join Date: Jul 2007

Posts: 4
Rep Power: 0 MotoTiller is on a distinguished road
fTrader: (0)
fBuck$: 49
Bank: 0
Total fBuck$: 49

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

Edit: Uff, sorry - I should have read first then replied instead of the other way around.
MotoTiller is offline   Reply With Quote
Old 11-01-2007, 11:57 PM   #779 (permalink)
Member
 
Demiglot's Avatar
 
Join Date: Aug 2005

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

My Forumer
My Country:
Default Re: MySQL Database Error

Another message to pass along, and then I'll stop. I don't even know if this is useful to you:

Quote:
Whoops

ORDER BY
p.pid asc
LIMIT 260, 10); //20 <------------ AND HERE TOO

Looks like a miss placed end quote
Demiglot is offline   Reply With Quote
Old 11-02-2007, 12:09 AM   #780 (permalink)
Member
 
Anastasia5's Avatar
 
Join Date: Oct 2007

Posts: 18
Rep Power: 0 Anastasia5 is on a distinguished road
fTrader: (0)
fBuck$: 179
Bank: 0
Total fBuck$: 179

My Forumer
My Country:
Exclamation an error what should I do?

I am tried to access my topics and post or open a new one and I get this message

There appears to be an error with the @@@@@ ΒΕΡΑ ΣΤΟ ΔΕΧΙ + PLUS!!! 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 verastodexi_posts p
LEFT JOIN verastodexi_members m ON (p.author_id=m.id)
LEFT JOIN verastodexi_groups g ON (g.g_id=m.mgroup)

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

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 '); //40' at line 10
mySQL error code:
Date: Friday 02nd of November 2007 01:05:39 AM



IS THIS A FORUMER ERROR OR I HAVE DONE SOMETHING WRONG ON THIS FORUM?
Anastasia5 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

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