vb.org Archive - Major Additions

Datenbankfehler in vBulletin 3.8.1:

Invalid SQL:
UPDATE dl_files SET `rating`=9,9 WHERE `id` = 7;

MySQL-Fehler : 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 '9 WHERE `id` = 7' at line 1
Fehler-Nr. : 1064
Fehler-Zeit : Monday, 16.03.2009 @ 13:55:37
Datum : Monday, 16.03.2009 @ 13:55:37
Skript : http://forum.computerbetrug.de/downl...id=7&rating=10
Referrer : http://forum.computerbetrug.de/downl...p?do=file&id=7
IP-Adresse : 77.20.165.139
Benutzername : Heiko
Klassenname : vB_Database_MySQLi
MySQL-Version : 5.0.32-Debian_7etch8-log

Any clue how to fix this?

darknusens

03-16-2009 02:38 PM

What are the names of the tables that get written to the database for this mod?
I see there might be about 8 but I'm not sure.
The ones I think they are are,

1. dl_cats

2. dl_comments

3. dl_downloads

4. dl_files

5. dl_images

6. dl_main

7. dl_stats

8. dl_votes

is there any other tables that are associated with downloadsII That I need to know about? The reason I want to know is for backup purposes.

RS_Jelle

03-16-2009 03:17 PM

Quote:

Originally Posted by Spenser (Post 1769560)

If rating a file there is an error:

Any clue how to fix this?

Strange, as I'm using sql_prepare which should take care of adding quotes to the value.
You're the first having problems with it :erm:

Try this: open downloads.php and find

PHP Code:


		
			
$db->query_write("UPDATE " . TABLE_PREFIX . "dl_files SET `rating`=".$db->sql_prepare($voteinfo['total']/$voteinfo['votes'])." WHERE `id` = ".$file['id']);

replace with

PHP Code:


		
			
$db->query_write("UPDATE " . TABLE_PREFIX . "dl_files SET `rating`='".$db->escape_string($voteinfo['total']/$voteinfo['votes'])."' WHERE `id` = ".$file['id']);

Quote:

Originally Posted by darknusens (Post 1769660)

That's all :)
+ some standard modifications to the user and usergroup table

Lyte	03-16-2009 09:37 PM

Quote:

Originally Posted by Lyte (Post 1762107)

I go the my Download page.... click Add from the Nav bar... fill everything out... open up my browser... select a zipped file... hit Add File and then I get this...

http://www.pc101.com/forum/images/dowload-error.bmp

Please advise. Thanks! Lyte

Hey RS Jelle,

Any thoughts on BullDog148th, Redzzand, popowich and my posts? We're all having problems loading files over 10MB.

I hope you'll help us too. This seems like a great hack that I'd like to get it working on PC101. :cool:

Thanks!

Lyte

UPDATE: Okay, I just noticed your update to the Download Details...

"Help!!! I can't upload large files?? This is probably the second most asked question. Have a look at this post for the solution."

I will give that a shot. Thanks!

solarweb

03-16-2009 09:51 PM

Hello, i´ve installed the mod and i´ve seen an error: 'Categories' and 'Import' options under 'Downloads' menu in admincp doesn´t work properly. When i try to go the main forum page load in the right frame.

Any idea to fix it?

Thank you very much!

popowich

03-16-2009 10:44 PM

Quote:

Originally Posted by Lyte (Post 1769989)

FWIW this is not an issue that seems fixable by increasing upload limits from a .htaccess or php.ini file. I can increase the limits far past a 30MB test file and can not get a 30MB test file uploaded. For example setting the limits to 100MB does not fix being able to upload a 30MB file. Any other ideas?

-Raymond

Lyte	03-17-2009 03:16 PM

Quote:

Originally Posted by Lyte (Post 1769989)

Hey RS Jelle,

Any thoughts on BullDog148th, Redzzand, popowich and my posts? We're all having problems loading files over 10MB.

Yeah, I'm afraid this post is not the answer. :(

Any thoughts RS Jelle regarding our plight?? :confused:

Lyte

All times are GMT. The time now is 04:06 AM.

Page 346 of 437

346

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03628 seconds Memory Usage 1,766KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: