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)
-   -   QuoteIt! Quote Management System v1.2 (https://vborg.vbsupport.ru/showthread.php?t=62470)

iamboard 03-18-2005 04:47 PM

I have a list of about 250 quotes that I want to put in. Is there a way to do an import if I can put these quotes into some time of importable format?

Thanks

CtrlAltDel 03-19-2005 05:57 AM

Yes the easiest way is to format them as SQL statements and then insert them with phpmyadmin or however you like to run sql commands against your database.

If you would like help writing out a SQL statement (you could just export your current quotes table to see what it would look like) I could help you out.

iamboard 03-19-2005 04:38 PM

Quote:

Originally Posted by CtrlAltDel
Yes the easiest way is to format them as SQL statements and then insert them with phpmyadmin or however you like to run sql commands against your database.

If you would like help writing out a SQL statement (you could just export your current quotes table to see what it would look like) I could help you out.

ctrlaltdel,

The quotes I have right now are all simply individual sentences. I have no experience with sql. I was hoping to put them maybe in a comma delimited format or something like that and import them. However, maybe a cut and paste method would be the easiest since I don't get very deep technically....your thoughts?

Thanks

seangworld 03-22-2005 12:17 AM

OK, ive gone thru some re-installing of my vbulletins a few times cuz i cant seem to decide what domain i really wanna use, and so whatever. lol

but basically, i JUST got around to upgrading my vb to 3.0.7 and re-installing this hack (1.2) and it works just fine. thought i'd let everyone know that.

also, for those that are writing the instructions and getting any upgrades to this hack ready in the future, it'd be nice if the instructions included step 7: edit and save any of the phrases without changing anything and then hit refresh on your forum and everything will be working fine.

ya, that woulda saved me about 15 minutes of looking for the answer to my question, lol, which i found on page 4 in the replies to this thread.

cyaz!

Dark Aura 03-22-2005 05:17 PM

Okay i tried to install this, but I have never run queries before why do I keep getting this error?

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; check the manual that corresponds to your MySQL server version for the right syntax to use near 'http://www.silent-imperfection.net/admincp/install_quoteit.php'

I have installed hacks before just not ones with queries, and they all work fine :confused:

Marco van Herwaarden 03-22-2005 06:50 PM

The line you are showing is not a query, but the path to the install script.

Dolamite 03-27-2005 04:01 AM

anyone seen this one yet?

Quote:

Database error in vBulletin 3.0.7:

Invalid SQL:
CREATE TABLE quotes (
`quoteid` int(10) unsigned NOT NULL auto_increment,
`quote` mediumtext NOT NULL,
`author` mediumtext NOT NULL,
`userid` int(10) unsigned NOT NULL default '0',
`approved` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`quoteid`,`quoteid`),
KEY `approved` (`approved`)
) TYPE=MyISAM AUTO_INCREMENT=1

mysql error: Duplicate column name 'quoteid'

mysql error number: 1060

Marco van Herwaarden 03-27-2005 06:23 AM

You have the column 'quoteid' 2 times in the primary key.

Dolamite 03-27-2005 12:35 PM

heh... marco... this ain't my code man :P i was just following the installation instructions....

it does seem to be there twice though.... not my doing..... but removing that 2nd instance seems to have solved the problem... so thanks for your help

Dolamite 03-27-2005 01:34 PM

well i said it was working.... but none of the admin menus got installed ... i've beening going thru adding some of this stuff manually.....

one thing i can't get is... how to show it on pages other than FORUMHOME.... such as my portal for example....


All times are GMT. The time now is 05:05 PM.

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.01510 seconds
  • Memory Usage 1,741KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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