vb.org Archive - QuoteIt! - Quote Database

Page 20 of 42

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - QuoteIt! - Quote Database (https://vborg.vbsupport.ru/showthread.php?t=97585)

vonedaddy

12-19-2005 12:35 AM

Quote:

Originally Posted by Cap'n Steve

vonedaddy - do NOT uninstall. Just reimport the the product and check the "allow overwrite" box. If there are any errors during installation, post them.

Did what you asked. Everything seemed fine, no errors during re-import. But it still gives me the same error when calling the quotes.php file.

Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT COUNT(*) AS quotes FROM vbquotes
WHERE approved = 1;

MySQL Error : Table 'vonaone.vbquotes' doesn't exist
Error Number : 1146
Date : Sunday, December 18th 2005 @ 06:34:20 PM
Script : http://hereyah.com/forum/quotes.php
Referrer :
IP Address : 68.46.5.248
Username : savone
Classname : vb_database

Cap'n Steve

12-19-2005 01:39 AM

That's really weird. Somehow it thinks you already have the quotes table when apparently you don't. Run these two queries to add the tables:

Code:

CREATE TABLE $TPquotes (

        quoteid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

        quote MEDIUMTEXT NOT NULL,

        author VARCHAR(75) NOT NULL,

        userid INT(10) UNSIGNED NOT NULL DEFAULT 0,

        approved TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        votes SMALLINT(10) UNSIGNED NOT NULL DEFAULT 0,

        rating MEDIUMINT(10) NOT NULL DEFAULT 0,

        average FLOAT(3, 2) NOT NULL DEFAULT 0.00,

        context VARCHAR(250),

        PRIMARY KEY (quoteid),

        INDEX (rating),

        INDEX (average),

        KEY approved (approved))

Code:

CREATE TABLE $TPquoteratings (

        quoteid INT(10) UNSIGNED NOT NULL,

        userid INT(10) UNSIGNED NOT NULL,

        rating TINYINT(1) NOT NULL,

        PRIMARY KEY (quoteid, userid))

As always, replace $TP with your table prefix.

vonedaddy

12-19-2005 02:05 AM

Got it, it didnt work at first but I noticed it created two tables.. One called $TBquotes and another called $TBquoteratings. So I ran the queries again and changed the names accordingly. It works now, thanks a million.

Also this is an awesome hack. Right now I am having some display problems but if I cant figure them out you will hear from me again. Thanks for this hack, and the support, two thumbs up.

vonedaddy

12-19-2005 02:06 AM

Quote:

Originally Posted by Cap'n Steve

As always, replace $TP with your table prefix.

DUH, Sorry. I just noticed that as I hit submit. I'm a moron, again thanks.

dieselpowered

12-19-2005 02:40 AM

Well I am not sure what happened, however, it refuses to save quotes now??? It was working, however, now when I attempt to add a quote it does not save it??

Any help would be appreciated!

Cap'n Steve

12-19-2005 02:46 AM

Does it give you an error? You may have to moderate the quotes before they show up if that option is on.

dieselpowered

12-19-2005 03:12 AM

Darnit, that is right, I turned on moderation. Sorry, I will have another drink... :)

dieselpowered

12-19-2005 03:25 AM

I would like to add the code to moderate the quotes within the moderation module in CMPS. I know the url to the moderation page, however, was curious if there was a way to place the number of quotes awaiting moderation next to the link.

Any thoughts? Thanks :)

Also, I had to delete a bunch of posts, now I have quotes 1-4 and then the next is quote #8. Is there any way to get the those numbers in sequence?

Cap'n Steve

12-19-2005 04:05 AM

Quote:

Originally Posted by xtremeoff-road

Check out this post.

Quote:

Originally Posted by xtremeoff-road

Also, I had to delete a bunch of posts, now I have quotes 1-4 and then the next is quote #8. Is there any way to get the those numbers in sequence?

Not right now. It's already been requested for the next version, though.

dieselpowered

12-19-2005 05:29 AM

Quote:

Originally Posted by Cap'n Steve

Check out this post.

No my friend, I am looking for the code to add to my CMPS moderation module so that I do not have to go into the admincp every time to check if new quotes have ben submitted.

Quote:

Originally Posted by Cap'n Steve

Not right now. It's already been requested for the next version, though.

I went into the db and manually changed it, thanks :)

All times are GMT. The time now is 01:17 PM.

Page 20 of 42

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01401 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 (2)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)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
Messages: