Coppermine database-error
Forum FAQForum FAQ   SearchSearch   Log in to check your private messagesLog in to check your private messages   LoginLogin
Post new topic   Reply to topic   Printer Friendly Page     Forum Index ⇒ Coppermine
View previous topic :: View next topic  
Author Message
murarn
Newbie


Joined: Aug 02, 2004
Posts: 26
Location: Sweden
PostPost subject: Coppermine database-error
Posted: Sat Oct 09, 2004 6:04 pm		 Reply with quote
I get this errormessage when i enter coppermine in my cpg-nuke 8.2b...

Code:
While executing query "SELECT *, a.title AS title, a.aid AS aid FROM nuke_cpg_pictures AS p INNER JOIN nuke_cpg_albums AS a ON (p.aid = a.aid AND visibility > -1  AND category >= 0) WHERE  approved = 'YES' GROUP  BY p.aid ORDER BY p.ctime DESC  LIMIT 0 ,4" on 0

mySQL error: Can't create/write to file '/root/tmp/#sql_7550_0.MYI' (Errcode: 13)

i had problem with mysql before this happened but i fixed that, I re-installed mysql and everything else works fine now...

murarn's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux(Debian)/1.3.31/4.0.21/5.0.2/8.2b
Back to top
View user's profile Visit poster's website MSN Messenger
Phoenix
Site Admin


Joined: Apr 19, 2004
Posts: 8729
Location: Netizen
PostPost subject: Re: Coppermine database-error
Posted: Sat Oct 09, 2004 6:18 pm		 Reply with quote
Try running 'repair' on your database.
_________________
• DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin •

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
murarn
Newbie


Joined: Aug 02, 2004
Posts: 26
Location: Sweden
PostPost subject: Re: Coppermine database-error
Posted: Sun Oct 10, 2004 1:11 pm		 Reply with quote
Quote:
Try running 'repair' on your database.

ok, it worked! Embarassed

I tried run 'repair' on the database and then restarted the server and now it works... Big grin

Thanks for your help Very Happy

murarn's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux(Debian)/1.3.31/4.0.21/5.0.2/8.2b
Back to top
View user's profile Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic   Printer Friendly Page     Forum Index ⇒ Coppermine All times are GMT
Page 1 of 1


Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Dedicated Server & Bandwidth Sponsored by DedicatedNOW
User Info [x]

Welcome Anonymous
Nickname
Password
(Register)

Last CVS commits [x]

Languages [x]

Community [x]

Support for DragonflyCMS in a other languages:

• Deutsch
• Español

X-links [x]
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

Preview theme [x]
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.


You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
This page generated in 0.3595 seconds with 16 DB Queries in 0.0956 seconds
Memory Usage: 2.87 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy