 |  |  |  |  |  |  |  |
Data Base error
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I installed script .It was working fine since one month but today this error is coming.Please be advice.
Thanks
Link
Thanks
Link
SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp, ct.cityname, COUNT(*) AS piccount, p.picfile, scat.subcatname, cat.catid, cat.catname FROM clf_ads a INNER JOIN clf_cities ct ON a.cityid = ct.cityid INNER JOIN clf_subcats scat ON a.subcatid = scat.subcatid INNER JOIN clf_cats cat ON scat.catid = cat.catid LEFT OUTER JOIN clf_adxfields axf ON a.adid = axf.adid LEFT OUTER JOIN clf_adpics p ON a.adid = p.adid AND p.isevent = '0' LEFT OUTER JOIN clf_featured feat ON a.adid = feat.adid AND feat.adtype = 'A' WHERE scat.catid = 1 AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND (feat.adid IS NULL OR feat.featuredtill < NOW()) AND a.cityid = 21 GROUP BY a.adid ORDER BY a.createdon DESC LIMIT 0, 50Can't create/write to file '/root/tmp/#sql_ddc_0.MYI' (Errcode: 2) 
•
•
Join Date: Nov 2007
Posts: 84
Reputation: 
Solved Threads: 14
Junior Poster in Training
MySQL Syntax (Toggle Plain Text)
might be a permissions issue. Make sure folder /root/tmp/ has writable permissions
|
Similar Threads
- Send data on a serial port (C++)
- Kernel Data Inpage Error, Portege 7000ct (Troubleshooting Dead Machines)
- Vb6 Data Report Error (Visual Basic 4 / 5 / 6)
- conversion of text file into data base file (Visual Basic 4 / 5 / 6)
- "Input past end of File" error #62 (Legacy and Other Languages)
- memory error in vb6 (Visual Basic 4 / 5 / 6)
- vb6 error help me (Visual Basic 4 / 5 / 6)
- winsock.scr and op error/virus (Viruses, Spyware and other Nasties)
Other Threads in the MySQL Forum
- Previous Thread: external database connection
- Next Thread: New to joins - Need help with query...
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop legal license licensing linux maintenance mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization