I've searched and seen similar, but not exact versions of this problem.
HistoryClean install of SMF 1.1.3 and TP 0.9.8. Installed CityScape-TP theme. Everything working well. This site is meant to be a communication and digital music (PDF parts, not MP3s) distribution portal for my 85-member civic wind ensemble.
Started configuring the Downloads area. FTPed 5 files into the appropriate folder with appropriate permissions to use the "FTP" section of the Downloads Admin to add them to the proper Download category.
The IssueGot a database error and a warning stating that my database was one version back (1.1.2) from the forum, and that I needed to run the upgrade.php in the latest SMF "Large Upgrade" package.
Did so. It trashed my TinyPortal installation, but no matter--re-added the package, everything well again.
Tried the FTP/Downloads Admin bit again.
Warning about mismatched versions is gone, but I get this:
QuoteYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, '', '', 1, '','','')' at line 2
File: /home/virtual/site1/fst/var/www/members/Sources/TPdlmanager.php
Line: 986
That's the bit that starts...
Quote// now go through each file and put it into the table.
foreach($_POST as $what => $value){
etc...
Obviously it's unhappy with the SQL INSERT statement, but before I start hacking on the code myself, some input from a more seasoned user of TinyPortal would be appreciated.
The downloads area, as noted above, will be the "guts" of this new site, so I am concerned about this.
Kind regards,
Dr. Richard L. Byrd
Music Director, The Woodlands Concert Band
The Woodlands, TX
http://woodlandsband.com
At the moment all I can do is confirm the error as I get it as well with a site that was upgraded from SMF 1.1 Final to 1.1.2 to 1.1.3
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 ' 0, '', '', 1, '','','')' at line 2
File: /###################/Sources/TPdlmanager.php
Line: 986
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php.
Yes, this is precisely the error I was getting before running upgrade.php. As stated above, now the upgrade message is gone, but the SQL error regretfully remains.
r
Try this file, I have sucessfully assigned an FTP file using it.
Many thanks, but the error remains the same.
Further research indicates that only certain files cause this behavior. Does not seem to be related to the length of the file name, the size, nor the filetype, nor the existence of spaces or such in the filename.
Exceptionally frustrating.
STRIKE THAT.
PROBLEM FOUND.
Despite the filenames showing correctly in the FTP section of Download Admin, and despite the query escaping them properly, ANY filename with a single tick (') fails on the mass addition to the database.
Real solution: spend time finding out WHY!
Quick solution: s/\'//g;
Thanks for the assistance.
r
Would you believe that of the three files I ftp'd I chose the only one without a ' in the file name to test with.
Glad it is sorted.
*bangs head on desk*
It's not.
Got the files IN the database--they won't download. Click on "Download," blank screen. Nothing in the error_log. I guess I'm going to hunt up another mod, dammit.
*sigh*
This also happens on an alpha version I'm testing. :(
I have posted this problem on our admin board to bring it to Bloc's attention.
Still pokin' around. It seems that when you delete a file from the database, vestiges of it remain. I can probably get mine to work, but it'll involve running a few queries by hand.
Lemme know what Bloc says...
r
I'm getting an identical error here. Anything I can do to help locate the cause of the problem?
Edit: it's definitely any filename with a ' in it, like "player's".
I've also noticed that it likes to put any file I assign to a category into a new category named "no name" under the one I assign. It'll do this in batches, meaning if I select multiple files, they'll all end up in the same "no name" category. I'm guessing that's a known bug tho, as it's fairly obvious and easy to spot. :)