vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   VB-O-GRAM ....... Site Promotional Tool (https://vborg.vbsupport.ru/showthread.php?t=74912)

docvader 01-23-2005 05:06 PM

When trying to insert this query
Quote:

CREATE TABLE `vbogram_card` (
`vbogram_cardid` int(11) NOT NULL auto_increment,
`sendername` varchar(100) NOT NULL default \'\',
`senderuserid` int(11) NOT NULL default \'0\',
`senderemail` varchar(100) NOT NULL default \'\',
`imageid` int(11) NOT NULL default \'0\',
`message` mediumtext NOT NULL,
`receiveremail` varchar(100) NOT NULL default \'\',
`receivername` varchar(225) NOT NULL default \'\',
`cardid` varchar(20) NOT NULL default \'0\',
`datestamp` int(11) NOT NULL default \'0\',
`reply` tinyint(4) NOT NULL default \'0\',
PRIMARY KEY (`vbogram_cardid`))
I get this response:
Quote:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near '\'\',
`senderuserid` int(11) NOT NULL default \'0\',
`senderemail` varchar' at line 3
Got any suggestions?

yoyoyoyo 01-23-2005 05:10 PM

Quote:

Originally Posted by docvader
OH, and YOYO


I always got my death threats in person. Not by VB-O-GRAMS.

lol...

I know that it is extremist thinking, but I deal alot with computer security issues for a living, so when I see something like this I naturally notice such things. Many such services have been discontinued due to abuse on sites, or they install limits and filters to avoid these nuisances, so I was just trying to add my .02 to the hack, and was hoping that Trafix might be able to add in a few extra options in the ACP to cover these issues, since this is a great addition to a site!

miz 01-23-2005 06:27 PM

Quote:

Originally Posted by docvader
Trafix,

Stayed up all night looking for swf files to include in this potentially wonderful communication method.

My girlfriend hates you.

Anyway, tried to install it this morning, and got this during install:



But, with perseverance and fortitude, I continued. The link in the nav bar causes this, not surprisingly:



OH, and YOYO


I always got my death threats in person. Not by VB-O-GRAMS.

lol...

rich

( I'll dig around in your install file and try to install this manually...)

some servers dont use mysql database on localhost or something like that
that makes problem with the install
its happend to hacks i coded also on 1 of my servers
so ill recommand that you will user the phpmyadmin tool that supplied with host and to insert this query
[SQL]CREATE TABLE `vbogram_card` (
`vbogram_cardid` int(11) NOT NULL auto_increment,
`sendername` varchar(100) NOT NULL default '',
`senderuserid` int(11) NOT NULL default '0',
`senderemail` varchar(100) NOT NULL default '',
`imageid` int(11) NOT NULL default '0',
`message` mediumtext NOT NULL,
`receiveremail` varchar(100) NOT NULL default '',
`receivername` varchar(225) NOT NULL default '',
`cardid` varchar(20) NOT NULL default '0',
`datestamp` int(11) NOT NULL default'0',
`reply` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`vbogram_cardid`))

[/SQL]

i removed all of \'\' cuse its uses on php thats why you didnt secced to enter this query manualy
try again with the query i gave u

docvader 01-23-2005 07:07 PM

OK, thanks. First table was apparently in there, second table worked via your method.

Now, I'm getting errors with these queries:
Quote:

ALTER TABLE '.TABLE_PREFIX.'language ADD `phrasegroup_vbogram` MEDIUMTEXT NOT NULL

INSERT INTO '.TABLE_PREFIX.'phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (885, 'vbogram', 'vB-O-Gram', 3)
I don't think its happy with the table prefix the way it's written. (I have no table prefix, as I upgraded from a 2.xx board a while back)

Thanks for the help. I'd like to get this to work.

Marco van Herwaarden 01-23-2005 07:14 PM

Quote:

Originally Posted by docvader
OK, thanks. First table was apparently in there, second table worked via your method.

Now, I'm getting errors with these queries:

I don't think its happy with the table prefix the way it's written. (I have no table prefix, as I upgraded from a 2.xx board a while back)

Thanks for the help. I'd like to get this to work.

If you are trying to run these queries manual, and don't use a prefix, change them like this:
[sql]ALTER TABLE language ADD phrasegroup_vbogram MEDIUMTEXT NOT NULL;

INSERT INTO phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (885, 'vbogram', 'vB-O-Gram', 3) [/sql]

boo.3 01-23-2005 07:39 PM

awesome!

will try out when i update to 3.0.6

trafix 01-23-2005 08:06 PM

Sorry guys ... i fixed the install script ...:)

docvader 01-23-2005 08:21 PM

Quote:

Originally Posted by trafix
Sorry guys ... i fixed the install script ...:)

No problem trafix. I forgive you.

My girlfriend doesn't...

LOL.

trafix 01-23-2005 08:35 PM

did you find any nice flash files?

PS your not the only one that get thrown in the doghouse if you sit infront of the pc too long at night

trafix 01-23-2005 08:42 PM

I uploaded the waterfall swf zip file to the firat post ... you only need to upload vodopad.swf from the zip


All times are GMT. The time now is 09:49 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01240 seconds
  • Memory Usage 1,745KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete