Jätkuv SQL error

Igasugused vead mida sa Dragonfly kasutamise juures märganud oled.
Reply to topicReply to topic Printer Friendly Page
Forum FAQSearchView unanswered posts

Jätkuv SQL error

Post Posted: 21.11.08. 23:21:58

Ma paluksin sellise asja juures nõu.. kunagi vist kirjutasin ka, aga ma ei leia enam teemat ülesse. Saan pidevalt (ikka mitu mitu korda päevas) meilile veateate ja seda juba pikemat aega:

On /index.php?name=Forums&file=viewtopic&t=23678&start=15&postdays=0&postorder=asc&highlight=
While executing query "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.bio, u.user_timezone, u.user_occ, u.user_interests, p.*, pt.post_text, pt.post_subject, u.user_lisarank, u.user_lisarank_algus FROM cms_bbposts p, cms_users u, cms_bbposts_text pt
WHERE p.topic_id = 23678

AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time ASC
LIMIT -15, 15"

the following error occured: 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, 15' at line 7

In: /var/www/pereklubi/modules/Forums/viewtopic.php on line: 312

Guest information:
User id: 1
Username: Anonymous
Admin: No
IP: 193.40.20.249
Host: cache.kliinikum.ee


Ma saan aru, et kuskil on mingi viga.. ilmselt seal kirjutatud real, aga vat mina seda küll üles ei leia ju. Äkki keegi kooditark oskab vihjata?
Panin faili siia:
www.pereklubi.com/kris...wtopic.rar

Ma olen hästi tänulik kui keegi oskab vihjata midagi
_________________


piraja's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux / 2.0 / 5.0.45 / 5.2 / 9.2.1

piraja
Tõlkija
Tõlkija
 

Re: Jätkuv SQL error

Post Posted: 5.11.09. 21:52:49

dragonflycms.org/Forum...31/#150231

Madis's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.0.63/5.0.67/5.2.5/9.2.1

Madis
Administraator
Administraator
 

Re: Jätkuv SQL error

Post Posted: 5.01.10. 22:19:06

No vaatame, sättisin koodi veidi, ehk aitab. Tänud lingi eest!
_________________


piraja's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux / 2.0 / 5.0.45 / 5.2 / 9.2.1

piraja
Tõlkija
Tõlkija
 

Re: Jätkuv SQL error

Post Posted: 7.01.10. 23:18:52

Enam pole selliseid erroreid tuld. Väga timm!
_________________


piraja's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux / 2.0 / 5.0.45 / 5.2 / 9.2.1

piraja
Tõlkija
Tõlkija
 
Page 1 of 1



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 can download files in this forum