You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 259 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Attachment mod SQL error? [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
pdt
Nuke Cadet
Nuke Cadet


Joined: Oct 20, 2004
Posts: 1


PostPosted: Mon Dec 12, 2005 4:32 am Reply with quoteBack to top

I get the following message when i click on submit for a post with an attachment. The post succeeds but the attachments doesnt. Mod version 2.3.6

Couldn't store Attachment.
Your post has been stored.

Quote:
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 ' 0)' at line 1

INSERT INTO nuke_bbattachments (attach_id, post_id, privmsgs_id, user_id_1, user_id_2) VALUES (5, 3933, 0, , 0)

Line : 769
File : posting_attachments.php


How do i fix this? Confused
Find all posts by pdtView user's profileSend private message
Xyberian
Colonel
Colonel


Joined: Mar 14, 2004
Posts: 1939

Location: Behind you

PostPosted: Mon Dec 12, 2005 7:19 am Reply with quoteBack to top

your installation of attachment mod was wrong in posting.php and posting_body.tpl. double check those files.

_________________
Home of the Enterprise PHP-NUKE
Find all posts by XyberianView user's profileSend private messageVisit poster's website
Kraftwerk
Nuke Cadet
Nuke Cadet


Joined: Oct 25, 2005
Posts: 5


PostPosted: Fri Nov 09, 2007 8:39 am Reply with quoteBack to top

Any other solutions?

I have this same error with the same mod and wondering what else could be an issue.

-=Kraft=-
Find all posts by KraftwerkView user's profileSend private message
Kraftwerk
Nuke Cadet
Nuke Cadet


Joined: Oct 25, 2005
Posts: 5


PostPosted: Fri Nov 09, 2007 10:10 am Reply with quoteBack to top

By the By.

I fixed this error - only by taking a posting_attachments.php from another website I set up years ago and it worked. I don't know why - but it did. There was nothing in the posting.php or posting_body.tpl that needed to be fixed, there was a line of code in posting_attachments.php that was giving me an error.

I don't know what the rules are here on posting links to stuff, but this is the posting_attachments.php in an .rar format. There's no viruses or anything, it is just my php file in an rar on my website - so if you are getting this problem, backup your files, and try this one.. What's the worst that can happen? It's already broke! lol

http://misfits.servegame.com:69/posting_attachments.rar

Good Luck,
-= Kraftwerk =-
Find all posts by KraftwerkView user's profileSend private message
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.166 Seconds - 407 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::