| User | Post |
|
3:36 pm
11 Oct 2007
|
rebekkah
Guest
| | | |
|
| |
|
|
Hi guys i got message error how i can fix it please help me
WordPress database 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 '-25, 25' at line 1]
SELECT SQL_CALC_FOUND_ROWS id,
name, url, date_format(start_date, '%D %b %Y') as start,
date_format(used_date, '%D %b %Y') as last, count, cat_id FROM
wp_download_count ORDER BY id ASC LIMIT -25, 25
|
|
|
|
|
I think there is a small bug that causes this on the first addition which I need to fis up. After the first addition it should go away and it is harmless.
|
|
|
4:16 pm
5 Dec 2007
|
Blue2script
Guest
| | | |
|
| |
|
|
I get the same error… and I already added two downloads. How can I fix that (WP 2.3)? Thanks in advance!!
Blue2script
|
|
|
|
|
Do yoiu mean that when you navigate away from the admin panel and then come back to it the error manifests itself again? As I said above it is a harmless error - and yes I will get around to fixing it but it shouldn’t keep happening.
Have you put a value in the options for how many items to show per page?
|
|
|
7:33 am
6 Dec 2007
|
kalesco
Guest
| | | |
|
| |
|
|
Hi there,
i have experienced the same thing.
maybe the $start variable is wrong?
it should be 0 I guess and not negative as long as there aren’t as many downloads as the $limit.
sorry for douple posting, but I hadn’t guessed that this is the same problem :)
|
|
|
|
|
Yes - it’s a little non-destructive ‘bugette’ I left lying around. What worried me (see above) was that it usually just happens when it is first used. I was waiting for ‘Blue2script’ to come back to me with more…
(I’l remove your other thread)
|
|
|
8:16 am
13 Dec 2007
|
kalesco
Guest
| | | |
|
| |
|
|
it should be 0 I guess and not negative as long as there aren’t as many downloads as the $limit.
I guess that this -$limit is the reason why the error occurred - 2 downloads as Blue2Script had would not be enough to get rid of the error.
But I guess you have tested it and did not experience this?
I can’t test it, as I have already altered the source and deleted the negative limit.
|
|
|
|
|
I’m going to try and find time to put a fix up today to stop it happening
|
|
|
6:21 pm
24 Dec 2007
|
jc
Member
| | | |
|
| posts 12 |
|
|
Hi Andy,
I’ve just installed Version 1.0 which I downloaded yesterday (download-manager.php 6,497 bytes 10 September 2007, 22:00:56) and I’m getting the same error:
(WordPress database 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 '-25, 25' at line 1]
SELECT SQL_CALC_FOUND_ROWS id, name, url, date_format(start_date, ‘%D %b %Y’) as start, date_format(used_date, ‘%D %b %Y’) as last, count, cat_id FROM wp_1download_count ORDER BY id ASC LIMIT -25, 25)
I’ve tried three times, and each time there is a red cross, have I missed the fix?
jc
|
|
|
|
|
No I haven’t had time to sort the fix. As it say above this is a non-destructive error and it has nothing to do with your red cross. That meansit cannot find the file you have positoned for download.
|
|
|
7:05 pm
25 Dec 2007
|
jc
Member
| | | |
|
| posts 12 |
|
|
Thanks. Could you help me find out what I’m doing wrong please:
The site url is http://voss.logicarts.com
The root folder is /voss (i.e. this is the folder which contains wp-app.php, wp-atom.php, wp-blog-header.php etc, and the sub-folders wp-admin, wp-content etc, and download-manager.php and a sub-folder called downloads).
/voss/downloads contains the file vo304525-GPL.zip
In Options and Settings, the Path to download-manager.php is
http://voss.logicarts.com/download-manager.php
and the Full path to download file folder is
/voss/downloads/
Then I create a download with Name: VOSS 3.045.25 and Download File Name: vo304525-GPL.zip in the (only) Category/Folder called downloads in the drop-down list.
I click Save Counter, and (ignoring the syntax error) when I list all counters, there it is, with the expected parameters, and a red cross.
I should be grateful for any help. Could it be significant that http://voss.logicarts.com is a sub-domain of logicarts.com?
jc
|
|
|
|
|
I run it in a sub-domain so that shouldn’t be a problem. Try changing the ‘Full path to download file folder’ to the complete path nstead of using a rea,ltive path and see if that solves it. Also check permissions oin your new downloads folder. If you have NO ‘categories/sub-folders’ defined then there should only appear the term ‘none’ in your drop down list of locations.
|
|
|
3:14 pm
26 Dec 2007
|
jc
Member
| | | |
|
| posts 12 |
|
|
I set chmod permissions on the ‘downloads’ folder to
Owner: read/write
Group: read
Other: read
but it made no difference.
The Category/Folder dropdown contains just ‘downloads’, which you say is wrong.
The highest level folder I have access to on the server is shown as ’/’ which contains sub folder ’voss’; how do I enter a complete path? My FTP client is WS_FTP Pro. I tried using
http://voss.logicarts.com/downloads/ and
http://voss.logicarts.com/voss/downloads/
but those are URLs, which you said not to use - didn’t help anyway. Still have just ‘downloads’ in the drop-down.
Btw, what is the significance of Download Speed, and why is it set so low?
Thanks,
jc
|
|
|
|
|
Does your ftp client show you the actual directory path? On a typical nix server that usually is something like:
/home/your_account/public_html/domain_name etc. An FTP client will usually show the path…?
The download ’speed’ really has a lot to do with how much ram is available. This detremines how big the ‘packets’ of information are that can be sent and the bigger the packets the quicker the download. I’d start off with a fairly big number like 1024 and adjust up or down as needed.
|
|
|
2:43 pm
27 Dec 2007
|
jc
Member
| | | |
|
| posts 12 |
|
|
All the FTP client shows when I connect is
/voss/wp-content/themes/theme229
and I can double-click up or down the folder hierarchy, but no higher than ‘/’, which contains sub-folders ‘cgi-bin’, ‘voss’, and ‘www’ (which is the top folder of my old, non-wordpress, website http://www.logicarts.com i.e. containing its ‘index.htm’). I have no access to nor knowledge of folders higher than ‘/’ on the server, it’s the root of my hosted service.
Re d/l speed, are you referring to ram on the server? Should I change ‘24′ to ‘1024′? I thought d/l speed was set by the server administrators, according to their hardware.
Regards,
jc
|
|
|
|
|
I’m sorry but I really just don’t see why ‘
/voss/downloads/’ should not work if everything else does. I’m stumped by this.
|
|
|
6:03 pm
27 Dec 2007
|
jc
Member
| | | |
|
| posts 12 |
|
|
I still have just ‘downloads’ in the Category/Folder dropdown, should that be ‘none’, even though /voss/downloads/ exists on the sever?
I tried setting all permissons read/write/execute, but that didn’t make any difference.
|
|
|
6:04 pm
27 Dec 2007
|
jc
Member
| | | |
|
| posts 12 |
|
|
What’s to procedure for uninstalling/re-installing?
|
|
|
|
|
It will remove the tables and the option records. It wil lleave your download files alone of course.
|
|
|
2:03 am
28 Dec 2007
|
jc
Member
| | | |
|
| posts 12 |
|
|
Progress! I’ve made it work by setting ‘Full path to download folder’ as:
../voss/
with a Category called:
downloads
(the file is in /voss/downloads/)
I created a Download Counter for Category:
downloads
which still shows the red cross, but the download works with the specified url in a hyperlink on a word in a Page. Good enough for me 
jc
|
|
Forums
