News:

SMF 2.0.19 has been released! Please update. Read more.

Main Menu

Download System

Started by SMFHacks.com Team, October 31, 2007, 06:55:37 PM

Previous topic - Next topic

Bulqr4eto

Ok I download this and try to install it again

now When I try to open the Category in the Downloads I get

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 '' at line 17
File: /usr/local/apache2/htdocs/rado/smf-bg.info/Sources/Downloads2.php
Line: 773


Line 773 in Downloads2.php is:

LIMIT $context[start]," . $file_limit);

$context['downloads_files'] = array();

while($row = $smcFunc['db_fetch_assoc']($dbresult))

{


Please, help I really want this addon :(

SoLoGHoST

Do you have a URL where I can see the error?

What version of SMF?  What version of Downloads System?  What other MODS, if any, are also installed?

What steps did you take to install this?  Please list the steps you've taken step by step, so I can see this, k?

Has anyone else got any errors like the 1 Bulqr4eto described above??  Will do a few more tests to try to see why you are getting this error Bulqr4eto.

If you have this AddOn Installed and working fine, please post up the URL so we can see it also, k?  Thanks!

SoLoGHoST

Oh, bytheway, here is a FRESH INSTALL of the Enhanced Downloads System AddOn, with just the Downloads System MOD and the Enhanced Downloads System AddOn ==> FRESH INSTALL of SMF 2.0 RC1 with Downloads System MOD 1.1.5.1 and ENHANCED Downloads System AddOn so I know it works perfect.  I have noted that you can change the background color yourself when applying the styles to the style.css files.

One Flaw in this install is that images from the default/images path do not have all of the images.  Tho, the your_themes/images path has all of the images, and you should copy all images from this path into Themes/default/images to ensure that you have all of the images for the default theme as well.

SoLoGHoST

Ok, Just Fixed this Flaw and re-upped @ Graphics Mayhem, well I had a ton of fun with this MOD, thanks very much vbgamer45.  Please take a look at it when you get a chance and if you like it, would very much like to see this addon incorporated into the Actual MOD itself.  I would be more than happy to help provide support for this MOD with you here and anywhere else.  Well let me know if that would be fine with you.

Thanks,
Solomon

Bulqr4eto

SoLoGHoST first thanks that you want to help me :) so am here we go

Here is what it say when I try to start install.php (I run it before 1 or 2 updates of your addon)

Notice: Undefined variable: scripturl in /usr/local/apache2/htdocs/rado/smf-bg.info/Themes/default/languages/Modifications.english.php on line 77

Notice: Undefined variable: scripturl in /usr/local/apache2/htdocs/rado/smf-bg.info/Themes/default/languages/Modifications.english.php on line 79

Notice: Undefined variable: scripturl in /usr/local/apache2/htdocs/rado/smf-bg.info/Themes/default/languages/Modifications.english.php on line 81

Error in Data Base
Duplicate column name 'layout'
File: /usr/local/apache2/htdocs/rado/smf-bg.info/install.php
Line: 52
Back


After I made the changes in Subs.php and everything else in the readme.txt here is what I get (see the attachments. The first pic is when I open the main download menu, the second is when I try to open a category

Here is the LINK but u need to register...




SoLoGHoST

Ok, there is no readme.txt file that you mention in my installation package.  The file that you should be looking at is the "How to INSTALL.txt" file.  This is the file that you should be reading.  If you do not have the right installation package, it is located here.  PLEASE PAY ATTENTION here, as DETAIL is the only thing we have to work with and is the only thing that will help you now.  I'm assuming that you have the correct version of SMF and Downloads System MOD installed as mentioned in the How to INSTALL.txt file.

FIRST, THIS STEP IS VERY IMPORTANT:
Please confirm that you have copied all files/folders (not including EXTRA INFO TXT Files, How to INSTALL.txt, Modifications.english.php EDITS.txt, and Subs.php EDITS.txt).  This means, you should have copied layout.js and ratings.js into your Themes/default/scripts directory relative to your SMF Root Directory.  If 1 or more folders do not exist in this path than create it.  Also, copy the folder (with the 2 folders inside of this folder) into the downloads/ directory.

IF you are still having problems after doing this... go on....

Would help if you were to give me these files, so I can see what has been done to them and make the changes to them myself, if needed:

1. Modifications.english.php
2. Downloads2.php
3. Downloads2.template.php
4. Subs.php
5. Downloads.english.php
6. Downloads.english-utf8.php
7. layout.js
8. ratings.js


Ok, and you need to check your database for the following tables and columns and confirm/deny these:

In Table:  smf_down_cat

Column name:  layout (you should only have 1 column, if you have more than 1 delete the 1 that doesn't have the values of -1, if none of these columns have the values of -1 and you still have more than 1, just delete them until you only have 1 column named layout)
all values by default should be:  -1

In Table:  smf_down_file

Column name:  actual_rating
Column name:  id_message
Column name:  ssThumb
Column name:  ssTables
Column name:  ssFilename


In Table:  smf_settings

You should not have the following values in the variable column:

1. down_set_files_per_page
2. down_set_files_per_page_normal
3. down_set_files_per_page_cool

You should have these variable column (value column):

1. down_set_files_per_page_list (value = 20)
2. down_set_rows_per_page_tables (value = 3)
3. down_set_files_per_page_full (value = 5)
4. down_set_file_rating_count (value = 1)
5. down_index_showtop (value = 0)
6. down_index_showbottom (value = 0)
7. down_index_showleft (value = 1)
8. down_index_showright (value = 0)
9. down_index_recent_order (value = 1)
10. down_index_mostviewed_order (value = 2)
11. down_index_mostdownloaded_order (value = 3)
12. down_index_mostcomments_order (value = 4)
13. down_index_toprated_order (value = 5)
14. down_index_recent_expand (value = 1)
15. down_index_mostviewed_expand (value = 0)
16. down_index_mostdownloaded_expand (value = 1)
17. down_index_mostcomments_expand (value = 0)
18. down_index_toprated_expand (value = 1)
19. down_set_file_ss_width (value = 0)
20. down_set_file_ss_height (value = 0)
21. down_set_cat_layout (value = 2)

Ok, you can just copy this text and place a YES/NO to the right of each of these if you have it, place YES, if you don't have it place NO.  Understand?  Don't worry, we will fix this together, but I need you to pay attention to DETAIL.

Thanks :)



Bulqr4eto

YeY we fix it ... it was because the old install.php didnt had the new tables... u have to make uninstall.php :P So it works now but why the categorys are in the right :( see HERE The new addon work only on the files not on categorys, right ?

SoLoGHoST

Ok, I don't speak Russian, my wife does, but she is not here now... at work.  So I can't answer the darn question to register on there because I don't understand what it is asking.  I suggest you temporarily allow guests to view the Downloads section in the permissions so that I can see what you are talking about, k?

SoLoGHoST

Quote from: Bulqr4eto on April 22, 2009, 03:03:02 PM
YeY we fix it ... it was because the old install.php didnt had the new tables... u have to make uninstall.php :P So it works now but why the categorys are in the right :( see HERE The new addon work only on the files not on categorys, right ?
No need for uninstall.php since the install.php will uninstall any prior versions if found.  New AddOn will work on files and categories.  I can't see the downloads page since you don't have permissions setup for guests to view it, and I don't understand the language on this site.  You can go to Permissions via a link at the Bottom of the Downloads Configuration Settings, link name is "Permissions", clicking this link will allow you to set Permissions for the Download System for Guest, Registered Users, etc. etc.  Please select Guests, and place a checkmark in View.

Bytheway, what language are you using on your forum?  My wife doesn't completely understand it either.  She said that it kinda looks like Bulgarian or something like that.

SoLoGHoST

Ok, I managed to get some help on registering at your site, but it is telling me "You are not allowed to view the Downloads"

So, it now comes down to the permissions.  Can you please setup your permissions in Admin->Downloads Configuration and click on "Permissions" link at the bottom of the page, set permissions for Registered Users, k?  Than I can take a look at what you are talking about.

Does that seem possible??  If so, let me know when you are done doing this so I can check it out.

SoLoGHoST

Ok, just realized that I had an older version of Downloads.english.php and Downloads.english-utf8.php in this package.  Ok, this fixes the empty text next to 3 text area's in Downloads Configuration, which should say:

Downloads per page (List View):
Rows per page (Tables View):
Downloads per page (Full View):

Empty your file cache again after overwriting these files into (relative to your SMF Root):

1. Themes/default/languages

and

2. Themes/your_themes/languages

your_themes = your personal theme folder name, basicall any folder in ./Themes.  So you will need to add these language files to all folders in ./Themes in the language folder.

Already fixed this in the package and reupped so it's all good if you download and install the package now.  Located ==> HERE

SoLoGHoST

Ok, am able to see your downloads section now.

1. Set your Screenshot Max Width and Max Heights in the "Downloads Configuration" to be a bigger size, looks good with a width of 400 - 600 pixels and height from 400 - 600 pixels.  This will not effect the size of the thumbnails in the Small Tables Layout and for the page index.  For Example, if you look at this page ==> http://smf-bg.info/index.php?action=downloads;sa=view;down=262 you will see a small pic and then a large one just underneath of it.  The large 1 just underneath of this pic would not be needed if you just set the Max Screenshot Width and Max Screenshot Height between 400 and 600 pixels, since they are both the same pic.  You will need to edit the download and re-up the Screenshot Image for this pic to be readded.  But if this is not your intention, do whatever, it's your site.

2. I am trying to duplicate a problem you are having with the Page Indexes shown on the right in IE (bytheway, looks fine in FF Browsers).  Although I can't seem to duplicate your issue.  Here is my attempt Page Blocks on Right.  As you can see it all looks fine.  I recommend redownloading the package, and overwrite Downloads2.php in sources again, and Downloads2.template.php in all of folders located within your ./Themes folder.  Be sure to overwrite them all.



Also, if you are wondering what happened to "My Files" and "Search" links, these are now Submenu options in the Main "Downloads" Menu.  You will need to have a drop down menu MOD installed, or a theme that supports this.  Here's a MOD you can install that will show the My Files & Search Submenu's when hovering over the Downloads Menu ==> BK-SMF Drop Down Menu

For those of you who do not wish to install the drop down menu mod above, it's a piece of cake to put these 2 links back into the Downloads Section Main Page.  Let me know if you need this, as I will  keep it as a submenu and also have it in the downloads section as well in the next update.

SA™

i have downloads set to not allow guest


yes i get this in my error logs any idea


http://sleepy-arcade.ath.cx/sleepy/index.php?action=downloads;sa=prev;id=41 
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 'AND approved = 1 AND ID_FILE > 41 LIMIT 1' at line 4


SELECT
ID_FILE
FROM smf_down_file
WHERE ID_CAT = AND approved = 1 AND ID_FILE > 41 LIMIT 1
File: C:/wayneker/htdocs/sleepy/Sources/Downloads2.php
Line: 4404 
http://samods.github.io/SAChatBar/

Xbox Live: smokerthecheese 360 or xbone
My Work
Piano Movers / Delivery service
QuoteMy allies are dead.
I'm 'bout to be too.
Zombies are chasing me.
F*** it, I'm screwed -___-

vbgamer45

Quote from: MAD Coder on April 24, 2009, 12:44:30 AM
i have downloads set to not allow guest


yes i get this in my error logs any idea


http://sleepy-arcade.ath.cx/sleepy/index.php?action=downloads;sa=prev;id=41 
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 'AND approved = 1 AND ID_FILE > 41 LIMIT 1' at line 4


SELECT
ID_FILE
FROM smf_down_file
WHERE ID_CAT = AND approved = 1 AND ID_FILE > 41 LIMIT 1
File: C:/wayneker/htdocs/sleepy/Sources/Downloads2.php
Line: 4404 

That is mostly caused by the file with ID of 41 being deleted and someone using the old file links still
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

SA™

oh i see thanks wonderd why it dont happen all the time just now and again  thanks
http://samods.github.io/SAChatBar/

Xbox Live: smokerthecheese 360 or xbone
My Work
Piano Movers / Delivery service
QuoteMy allies are dead.
I'm 'bout to be too.
Zombies are chasing me.
F*** it, I'm screwed -___-

SoLoGHoST

Yeah, this is located in the PreviousDownload() function.  So basically when a user clicks on the Previous Download Link. 

EDIT:
And since the Previous Download link still exists for the 1st download in a Category, when it would be better to not be there at all (since there is no previous download), I suppose clicking on it will generate that error.  Probably the same can be said about the Next Download Link also for the last download in a Category.  You can test this out by doing it yourself and clearing your error log just before clicking the Previous Download Link for the 1st download in any of your categories.

Marcus J

I like the look of the enhanced add on.  I really want the uploaded screen shot. 

What is preventing this from becoming part of the base package?

Sorry for my ignorant question.  I'm just curious. 

Cheers.

SoLoGHoST

Thanks Marcus J for your feedback.  Glad you like this AddOn.  Waiting for a response from vbgamer45...

Arveles

How can I add quick file upload in Simple Portal block?

Elveda SMF...

hartiberlin

Hi All,
I really need to move a big forum from
SMF 1.1.8/Tinyportal   to SMF 2.0RC1 with this Download
System.

Is there any option to rename the stored folder of the Tinyportal
Download Files into the VBgamer´s Download path and
just use some kind of PHP tool to put the files in the right
Download System Category ?

I really need to find a solution for this very soon,
cause I have to move about 260 Files this way from the TP Download
Section to the VBgamer´s Download System Categories.

How could I do this best ?

2. Is there any option to do this just via FTP and not single file by single
file manually ?
I want to avoid having to do it manually for all the 260 files...

Many thanks.

Regards, Stefan.

Advertisement: