All seems working so far (NEW INSTALL) because the update SQL contained some errors. Uploaded files and changed to updated files from 0.0.8. Added an file to DOWNLOAD but after click the category the files should be inside I got this
Code: Select all
DEBUG MODE
SQL Error : 1064 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' at line 10
SELECT f1.*, r.votes_file, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username FROM phpbb_pa_files AS f1 LEFT JOIN phpbb_pa_votes AS r ON f1.file_id = r.votes_file LEFT JOIN phpbb_users AS u ON f1.user_id = u.user_id WHERE f1.file_pin <> '1' AND f1.file_approved = '1' AND f1.file_catid = '2' GROUP BY f1.file_id ORDER BY LIMIT
Line : 255
File : /home/pafiledb/modules/pa_category.php
It also seems the CONFIGURATION settings I entered would not be saved !! And the display of the downloaded table / files wides my screen (1024 resolution) ??
The file is there and clicking directly to the file also displays everything fine, but the category the file should be inside is not displayed. ??