| Autor |
Nachricht |
cruspeed.
phpBB2.de User
Anmeldungsdatum: 27.05.2005
Beiträge: 51
|
 Verfasst am:
Mi 22 Feb, 2006 09:56 |
   |
I've installed 2 baords (1.53) on php5, one a fresh install and one an upgrade.
On both boards i'm getting this sql error.
ACP>Download>File Management-
| Zitat: |
Couldn't get file info
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 '' at line 5
SELECT file_name, file_approved, file_id, file_broken FROM phpbb_pa_files as f1 WHERE file_approved = '1' ORDER BY file_time DESC
Line : 248
File : admin_pa_file.php |
When I click on a category in the downloads secion, i get this error -
| Zitat: |
Couldn't get file info for this category
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 '' at line 10
SELECT f1.*, f1.file_id, r.votes_file, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, COUNT(c.comments_id) AS total_comments 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 LEFT JOIN phpbb_pa_comments AS c ON f1.file_id = c.file_id WHERE f1.file_pin = 1 AND f1.file_approved = 1 AND f1.file_catid = 4 GROUP BY f1.file_id ORDER BY
Line : 898
File : functions_pafiledb.php
|
Suggestions? |
|
|
    |
|
Google
|
| Verfasst am:
|
|
|
|
|
cruspeed.
phpBB2.de User
Anmeldungsdatum: 27.05.2005
Beiträge: 51
|
| Verfasst am:
Mi 22 Feb, 2006 10:10 |
|
i posted in the wrong area............please move to the support area |
|
|
|
|
cruspeed.
phpBB2.de User
Anmeldungsdatum: 27.05.2005
Beiträge: 51
|
| Verfasst am:
Mi 22 Feb, 2006 11:30 |
|
I just reinstalled a completely fresh copy of 1.53, even downloaded a new .zip file from here. same problem exists, same places. I haven't added any templates or changed anything, that is the first place I looked.
I'm running - php 5.0.5
MySql Version - 4.1.14-standard
Apache version - 1.3.34 (Unix)
phpBB 2.0.19
You can view the errors HERE |
|
|
|
|
Titus
Administrator
Anmeldungsdatum: 24.03.2004
Beiträge: 4255
|
| Verfasst am:
Mi 22 Feb, 2006 12:55 |
 |
exits the cache file in
pafiledb/cache/ called data_global.php ? |
_________________
"geht nicht" ist keine Fehlerbeschreibung mit der man was anfangen kann
bei Fragen erst suchen
Downloads gibts hier und da |
|
 |
|
cruspeed.
phpBB2.de User
Anmeldungsdatum: 27.05.2005
Beiträge: 51
|
| Verfasst am:
Mi 22 Feb, 2006 23:54 |
|
here is the complete pafiledb folder off my server. |
Zuletzt bearbeitet von cruspeed. am Do 23 Feb, 2006 00:47, insgesamt einmal bearbeitet |
|
|
|
Titus
Administrator
Anmeldungsdatum: 24.03.2004
Beiträge: 4255
|
| Verfasst am:
Do 23 Feb, 2006 00:19 |
|
is not inside
have the pafiledb/cache/ directory CHMOD 777 ?
here is the list of files und Directorys was needed spezialy permissions
| Zitat: |
#################################
#CHMOD to 777
#######
/album_mod/upload
/album_mod/upload/cache
/cache
/files
/files/thumbs
/images/avatars
/pafiledb/cache
/pafiledb/cache/templates
/pafiledb/images/screenshots
/pafiledb/uploads
#################################
#CHMOD to 666
#######
/includes/def_icons.php
/includes/def_themes.php
/includes/def_tree.php
/includes/def_words.php
/ctracker/logs/counter.txt
/ctracker/logs/logfile_flood.txt
/ctracker/logs/logfile_proxy.txt
/ctracker/logs/logfile_worms.txt
|
|
_________________
"geht nicht" ist keine Fehlerbeschreibung mit der man was anfangen kann
bei Fragen erst suchen
Downloads gibts hier und da |
|
|
|
cruspeed.
phpBB2.de User
Anmeldungsdatum: 27.05.2005
Beiträge: 51
|
| Verfasst am:
Do 23 Feb, 2006 00:27 |
|
okay, i'm going to totally re-install again. doing the chmods first. |
|
|
|
|
cruspeed.
phpBB2.de User
Anmeldungsdatum: 27.05.2005
Beiträge: 51
|
| Verfasst am:
Do 23 Feb, 2006 00:40 |
|
Still the same errors, you can see them HERE
And I had to create this folder /files/thumbs , as it was not in the beta8 download |
|
|
|
|
cruspeed.
phpBB2.de User
Anmeldungsdatum: 27.05.2005
Beiträge: 51
|
| Verfasst am:
Do 23 Feb, 2006 00:46 |
|
here are the files again, directly off my server.
**removed folder** |
Zuletzt bearbeitet von cruspeed. am Do 23 Feb, 2006 17:10, insgesamt einmal bearbeitet |
|
|
|
cruspeed.
phpBB2.de User
Anmeldungsdatum: 27.05.2005
Beiträge: 51
|
| Verfasst am:
Do 23 Feb, 2006 09:01 |
|
After thinking about the install on the new server, It maybe the php version 5.0.5 on the server. My old server is still active running php version 4.X, the download database worked fine on that server.
I'm going to setup a 1.52 and 1.53 default fisubsilversh board in the morning. If they work correctly with php version 4.X then it could only be a compatability issue with php 5.0.5. I'll post in the bugsubmit area if this should be the case. |
|
|
|
|
Titus
Administrator
Anmeldungsdatum: 24.03.2004
Beiträge: 4255
|
| Verfasst am:
Do 23 Feb, 2006 17:06 |
|
hmmm 
works all fine on Apache2.2.0 PHP5.1.1 + Mysql5.0.18 ! |
_________________
"geht nicht" ist keine Fehlerbeschreibung mit der man was anfangen kann
bei Fragen erst suchen
Downloads gibts hier und da |
|
|
|
maester
phpBB2.de User
Anmeldungsdatum: 07.06.2005
Beiträge: 61
|
| Verfasst am:
Di 04 Apr, 2006 23:06 |
|
not digging up an old subject but I have my forum from beta 5 all the way to beta 9 and the downloads database works have another forum that started at beta 8 and is beta 9 and getting the same error with the same exact server specs |
_________________
 |
|
|
|
|
|
|
|
![[netclusive - internet broadcasting]](templates/fisubsilversh/images/phpbb2_logor_01.gif)
