Paddy-v wrote: Hi, i recently installed File Attachment Mod Version: 2.3.14
everything worked sweet until i tried to view a topic and i got this error
Could not obtain topic information
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 'attach_setup_viewtopic_auth(, SELECT * FROM phpbb_config)' at line 5
SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments FROM phpbb_topics t, phpbb_forums f WHERE t.topic_id = 14 AND f.forum_id = t.forum_id attach_setup_viewtopic_auth(, SELECT * FROM phpbb_config);
Line : 155
File : viewtopic.php
i know how busy u guys are so if u could just explain what the problem is or what the error means it would be greatly appreciated
so i could maybe pin point if/where i went wrong & go about fixing it
thanks in advance![]()
Code: Select all
$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . "
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $join_sql_table . "
WHERE $join_sql
AND f.forum_id = t.forum_id
$order_sql";
attach_setup_viewtopic_auth($order_sql, $sql);
if ( !($result = $db->sql_query($sql)) )
bluntobject wrote: i cannot get download.php to display attatchments.. any help??
mosmos wrote: Hello,
I have a problem with the attachments.
First, when i upload pictures or files through using attachment mod, the files are now showing on the page(also there are no errors).
Second, when i try to put a image link or text in bbcode, it shows 2 same image and text on the topic page. I mean say i put 3 different image tag links and some text to the bbcode, it shows up with a 6 same images and 2 same text. It's really wierd tough because there isn't giving me an error or something. Just puts same whole message twice on the page.
Third, the column which is showing the number of attachments on the index page is not showing the numbers of the attachment and the text 'Attachments' which was on the right of the 'Topic' text is not shows up as well.
Could someone help me to fix those errors?
Thank you.
Code: Select all
//
// Allowed Syntax:
// Full Domain Name -> www.opentools.de
// Partial Domain Names -> opentools.de
//
$sites = array(
$board_config['server_name'], // This is your domain
'opentools.de',
'phpbb.com',
'phpbbhacks.com',
'phpbb.de'
);
Code: Select all
$board_config['server_name']
wizard james wrote: guess i till toss my info in here..
creede i know what its like installing on that template..and its a very very large pain.. (nothing like getting it to work on some of doublej's styles) but i can try to help u out but need more info as the template may already been touched i need to see the posting_body.tpl (dont paste it all here.. either PM me it, IM me it, or Pastebin it
mosmos, id wait till tux stops in.. am good with the template and editing stuff ..
kicktd : are u sure u put the files from the templates of the mod into the templates/*/admin/
if u think u did, recopy all the files from the templates folder of the mod download
footer: make sure u copyed the lang files into the right lang folders and did the right lang files edits
chrisjchrisj wrote: I have the Attachment MOD, but I'm not seeing how to add attachments, when I post or view the topic.
I am sure it's just a setting, that is not enabled, but I've looked and looked, I have trialed and errored, and I'm out of ideas.
What am I forgetting? Can someone offer suggestions as to what settings I should look at?
Or offer other suggestions? It just seems like it a topic viewing issue, but I'm stumped.
Thanks. I look forward to any guidance here.
Tux_Rules wrote:bluntobject wrote:i cannot get download.php to display attatchments.. any help??
How are your permissions set up? Set them to REG for download and Post.
ACP -> Forum Admin -> Permissions -> Advanced Mode
EDIT: I see it is now working?
http://www.pediscussions.com/viewtopic.php?p=2392#2392
Attachment is visible 8)
bluntobject wrote:Tux_Rules wrote:bluntobject wrote:i cannot get download.php to display attatchments.. any help??
How are your permissions set up? Set them to REG for download and Post.
ACP -> Forum Admin -> Permissions -> Advanced Mode
EDIT: I see it is now working?
http://www.pediscussions.com/viewtopic.php?p=2392#2392
Attachment is visible 8)
tux - yeah the attachments are visible now.. i was just scrolling to fast and didnt see the error it was giving me up top about file permissions not allowed.. went and fixed that.. good to go for uploading now.
i went and changed all my category permissiong to reg/reg for post/view and still no luck.. i dont even remember there being any code in the install for download.php being placed on the index or anything..
here's exactly what i looking to have:
http://www.opentools.de/board/attachments.php
http://www.mightygorgon.com/attachments.php