Downloads Error: PHPFusion 6 Support

Home
Search

Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.

Hey,
when i go to my categories for download, i'm getting the following error ...

Quote

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 'LIMIT 0,15' at line 1You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,15' at line 1

any ideas how and why that happened? any ideas on how to fix it?
thanks for ur help!

Adnan.
http://mucus.sus.mcgill.ca

0 replies

Have you made any changes to the downloads.php file, Could you attatch it

0 replies

i believe i had mades some changes, but things didn't work so i just reloaded the file from back-up ... but that didn't do the trick either :S well here's my downloads.php file

thanx for ur help!

EDIT: just saw that my file wasn't attached, sorry ... here it is!

Edited by Reflectoman on 04-02-2006 22:57, 19 y

0 replies

Falk

answered 4 Feb 2006 at 01:00 PM

Super Admin

You need to edit and resave each download category in your admin panel.

0 replies

i went to the admin panel, clicked edit on the download category then clicked on Save category ... but it won't let me save it ... it goes right back to what it was before! :(

0 replies

can't make new categories either

0 replies

I have a similar problem, except this is for weblinks, I'm currently using version v6.00.303.

0 replies

any ideas, anybody? :(

0 replies

Falk

answered 7 Feb 2006 at 02:18 PM

Super Admin

Paste this into custom pages, preview it and paste the result here

Code Download source

<?php
$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}download_cats");
if (mysql_num_rows($result) > 0) {
echo "<table class='tbl-border'>\n<td colspan='2'><b>download_cats Table Scheme</b></td>\n";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td class='tbl1'>".$row[0]."</td><td class='tbl2'>".$row[1]."</td></tr>\n";
}
echo "</table><br>\n";
}

$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}weblink_cats");
if (mysql_num_rows($result) > 0) {
echo "<table class='tbl-border'>\n<td colspan='2'><b>weblink_cats Table Scheme</b></td>\n";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td class='tbl1'>".$row[0]."</td><td class='tbl2'>".$row[1]."</td></tr>\n";
}
echo "</table><br>\n";
}
?>

0 replies

Here's the output,

Quote

download_cats Table Scheme
download_cat_id smallint(5) unsigned
download_cat_name varchar(100)
download_cat_description text
download_cat_access tinyint(3) unsigned
download_parent tinyint(3)

weblink_cats Table Scheme
weblink_cat_id smallint(5) unsigned
weblink_cat_name varchar(100)
weblink_cat_description text
weblink_cat_sorting varchar(50)
weblink_cat_access tinyint(3) unsigned

Thanx very much for your help!

Edited by Reflectoman on 07-02-2006 15:30, 19 y

0 replies

Falk

answered 7 Feb 2006 at 03:06 PM

Super Admin

Run this code:

Code Download source

<?php
$res = dbquery("alter table {$db_prefix}downloads_cats drop download_parent");
echo "Done";
?>

Then edit and resave each download category in your admin panel.

Edited by Falk on 07-02-2006 16:07, 19 y

0 replies

:(
i got this error,

Quote

Table 'mucus.fusion_downloads_cats' doesn't existDone

btw, i had gone to a custom page, put the code, and did preview ... and that's what i got

Edited by Reflectoman on 07-02-2006 17:29, 19 y

0 replies

Falk

answered 7 Feb 2006 at 04:29 PM

Super Admin

My fault

Code Download source

<?php
$res = dbquery("alter table {$db_prefix}download_cats drop download_parent");
echo "Done";
?>

0 replies

the code worked, i got done ... i went and did edit then save category again... i even tried to make a new category, but it didnt work. i still get the same 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 'LIMIT 0,15' at line 1You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,15' at line 1

0 replies

digi, for the first code u gave me heres the result if i run it again...

download_cats Table Scheme
download_cat_id smallint(5) unsigned
download_cat_name varchar(100)
download_cat_description text
download_cat_access tinyint(3) unsigned

weblink_cats Table Scheme
weblink_cat_id smallint(5) unsigned
weblink_cat_name varchar(100)
weblink_cat_description text
weblink_cat_sorting varchar(50)
weblink_cat_access tinyint(3) unsigned

0 replies

Falk

answered 7 Feb 2006 at 04:44 PM

Super Admin

This should fix it

Code Download source

<?php
$result = dbquery("ALTER TABLE ".$db_prefix."download_cats ADD download_cat_sorting VARCHAR(50) DEFAULT 'download_title ASC' NOT NULL AFTER download_cat_description");
echo "download_cat_sorting fixed";
?>

0 replies

Beautiful!

again, thanx a lot digi...without phpfusion and ur help a lot of us would be totally lost, myself included! Thanx!

0 replies

Digitanium, for the first code I get:

?php $result = mysql_query("SHOW COLUMNS FROM {$db_prefix}download_cats"); if (mysql_num_rows($result) > 0) { echo "\n\n"; while ($row = mysql_fetch_array($result)) { echo "\n"; } echo "
download_cats Table Scheme
".$row[0]." ".$row[1]."

\n"; } $result = mysql_query("SHOW COLUMNS FROM {$db_prefix}weblink_cats"); if (mysql_num_rows($result) > 0) { echo "\n\n"; while ($row = mysql_fetch_array($result)) { echo "\n"; } echo "
weblink_cats Table Scheme
".$row[0]." ".$row[1]."

\n"; } ?>

0 replies

My problem is that I can't make new dowload categories and I get the following error message when trying to access weblinks:

Quote

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 'LIMIT 0,15' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,15' at line 1

Edited by tefo on 09-02-2006 01:02, 19 y

0 replies

— 6 months later —

I searched on here for a couples days till I found this thread... Digitanium, your a genius!!! Thanks for the fix.

0 replies

Category Forum

Bugs and Errors - 6

Labels

None yet

Statistics

Views 0 views
Posts 19 posts
Votes 0 votes
Topic users 5 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Downloads Error

19 posts

PHPFusion

Resources

Community

Development