•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 401,639 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,805 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 312 | Replies: 1
 |
•
•
Join Date: Dec 2007
Posts: 21
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
Data Base error 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) 
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
access advice algos breach business code combo crime daniweb data data protection data transfer database drive dropdownlist encryption europe forensic forensics fortitude fun government hard hardware help hitachi hope hp industrial espionage information internet it linux module net news payment services privacy protection reuse security storage struggle terabyte trial-and-error tutorials and more victory web wikipedia you tried to assign the null value to a variable that is not a variant data type
- 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...
