vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Mini Mods - BFC-Quote (https://vborg.vbsupport.ru/showthread.php?t=212175)

Excalibur82 05-01-2009 06:00 AM

Prisim: Not to sound rude but did you read this thread? I am aware of those errors and I have posted that I am working on them currently.

Excalibur82 05-02-2009 04:29 AM

Almost have v1.3 complete with usergroup perms and various errors fixed.

Sweeks 05-03-2009 11:26 AM

Cant wait :)

odln018 05-05-2009 07:21 PM

I put this into my prod forum, but it says I don't have permissions. Where would I set this?

macc 05-05-2009 07:40 PM

hello!

tried to install first time and get this database error

Code:

Invalid SQL:
ALTER TABLE `quotes` ADD `unapproved` TINYINT( 1 ) NOT NULL;
MySQL Error  : Table 'belapla_libar.quotes' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, May 5th 2009 @ 04:30:57 PM
Error Date    : Tuesday, May 5th 2009 @ 04:30:57 PM
Script        : http://libar-libar.com/libar/vb/admi...=productimport
Referrer      : http://libar-libar.com/libar/vb/admi...?do=productadd
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.0.67-community

some help?

have vb 3.8.2

reg
macc

Excalibur82 05-05-2009 07:47 PM

odln018: Permissions are controlled through the usergroups.

macc: Not to sure what is causing that error. I will check it out and get an update released.

Leica.Robbiani 05-05-2009 08:03 PM

Hi there,

when the ?Author?-line contains a ?'?, this Mod throws an database error.

Just another thing:
I had to change in every file the ?TABLE_PREFIX quotes ...? in something other (I've chosen ?fortunes?), because my database had already a table called ?quotes?. Why don't you call the whole Mod ?fortune?, because it's just the same as the little program ?fortune? on any Linux System with the games-section installed. So the chance will be great, that there's no conflicts with ?quotes?.

Best regards

Leica.Robbiani

macc 05-05-2009 08:20 PM

have you some fix Leica?

macc

Excalibur82 05-05-2009 09:05 PM

Leica.Robbiani: The author box shouldn't have ' as no username has an ' but if its say Italian or something I'll see what I can do to fix the issue, otherwise for the time just avoid using ' when adding an author name.

Now on the issue of the DB, I can probably change it to bfc_quotes instead that way it will be unique and I am the only one who codes using the name of bfc_ so I'll see how that works out.

macc 05-05-2009 09:09 PM

Have you some solution for my database error ?

reg
macc

Excalibur82 05-05-2009 09:46 PM

macc: Try installing using the product xml file I have attached to this post and tell me the results.

odln018 05-05-2009 10:46 PM

Quote:

Originally Posted by Excalibur82 (Post 1805278)
odln018: Permissions are controlled through the usergroups.

macc: Not to sure what is causing that error. I will check it out and get an update released.

I must be blind, because when I try to edit the usergroup, I'm not seeing a BFC Quote option.

Excalibur82 05-06-2009 01:26 AM

odln018: What version of vB are you using?

Leica.Robbiani 05-06-2009 02:14 AM

Hi,

Quote:

Originally Posted by Excalibur82 (Post 1805345)
Leica.Robbiani: The author box shouldn't have ' as no username has an ' but if its say Italian or something I'll see what I can do to fix the issue, otherwise for the time just avoid using ' when adding an author name.

Well, a username can be Georgia O'Keefe, and so there will be of course an ?'? in the username ...

So it will be great if you have a solution for the problem.

Thanks a lot, anyway it's a great mod.

Best regards

Leica.Robbiani

Excalibur82 05-06-2009 06:09 AM

Leica.Robbiani: Yeah you are correct, I don't know what I was thinking or doing when I said that. There is a solution but I won't be able to implement it till tomorrow once I've had some sleep.

odln018 05-06-2009 09:29 AM

Quote:

Originally Posted by Excalibur82 (Post 1805520)
Leica.Robbiani: Yeah you are correct, I don't know what I was thinking or doing when I said that. There is a solution but I won't be able to implement it till tomorrow once I've had some sleep.


I'm using 3.8.1 for both boards (test and production)

macc 05-06-2009 01:34 PM

Quote:

Originally Posted by Excalibur82 (Post 1805378)
macc: Try installing using the product xml file I have attached to this post and tell me the results.

i tried this file but when instal get error "eval code on line 6..." when tried to uninstall get this error
Code:

Database error in vBulletin 3.8.2:
Invalid SQL:
DROP TABLE `quotes`;
MySQL Error  : Unknown table 'quotes'
Error Number  : 1051
Request Date  : Wednesday, May 6th 2009 @ 10:23:05 AM
Error Date    : Wednesday, May 6th 2009 @ 10:23:05 AM
Script        : http://libar-libar.com/libar/vb/admi...do=productkill
Referrer      : http://libar-libar.com/libar/vb/admi...id=bfc_quote&s=
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.0.67-community


and in my admincp - when click on manage quotes get this database error
Code:

Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT * FROM `quotes` ORDER BY username ASC;
MySQL Error  : Table 'belapla_libar.quotes' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 6th 2009 @ 10:26:41 AM
Error Date    : Wednesday, May 6th 2009 @ 10:26:41 AM
Script        : http://libar-libar.com/libar/vb/admincp/quotes.php
Referrer      : http://libar-libar.com/libar/vb/admi...dex.php?do=nav
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.0.67-community


please some help -

regards

macc

macc 05-06-2009 01:38 PM

now my forum page works not - get this error

Code:

Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT * FROM quotes WHERE unapproved = 0 ORDER BY RAND() LIMIT 1;
MySQL Error  : Table 'belapla_libar.quotes' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 6th 2009 @ 10:29:29 AM
Error Date    : Wednesday, May 6th 2009 @ 10:29:29 AM
Script        : http://libar-libar.com/libar/vb/index.php
Referrer      : http://libar-libar.com/libar/vb/admi...ex.php?do=head
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.0.67-community

some help?

macc

EnIgMa1234 05-06-2009 02:57 PM

Run the following query from the admincp->maintenance->execute sql query

[SQL]CREATE TABLE `quotes` (
`id` int(4) NOT NULL auto_increment,
`quote` mediumtext NOT NULL,
`username` varchar(255) NOT NULL default,
`unapproved` TINYINT( 1 ) NOT NULL",
PRIMARY KEY (`id`)
)[/sql]

Use this at your own risk.

macc 05-06-2009 03:21 PM

tried from phpmyadmin but get error -
my board and admincp - not accessible ...

some help ?

macc

edit - this error come up
Code:

ERROR: Oavslutat citat @ 174STR: "SQL: CREATE TABLE `quotes` (  `id` int(4) NOT NULL auto_increment,  `quote` mediumtext NOT NULL,  `username` varchar(255) NOT NULL default,  `unapproved` TINYINT( 1 ) NOT NULL",  PRIMARY KEY  (`id`))

Leica.Robbiani 05-06-2009 03:37 PM

Hi,

Quote:

Originally Posted by Excalibur82 (Post 1805520)
Leica.Robbiani: Yeah you are correct, I don't know what I was thinking or doing when I said that. There is a solution but I won't be able to implement it till tomorrow once I've had some sleep.

No problem, as far as I know about the problem I can live with it for a while. I know, sometimes a coder doesn't know is the head under the knees or above them ...

Have a nice sleep.

Best regards

Leica.Robbiani

macc 05-06-2009 03:56 PM

some help for my problem?

i disabled all plugins and on my home page get this error

Fatal error: Call to undefined function print_portal_output() in /home/belapla/public_html/libar/vb/cmps_index.php on line 46


reg

macc

EnIgMa1234 05-06-2009 04:15 PM

Quote:

Originally Posted by macc (Post 1805829)
some help for my problem?

i disabled all plugins and on my home page get this error

Fatal error: Call to undefined function print_portal_output() in /home/belapla/public_html/libar/vb/cmps_index.php on line 46


reg

macc

Well vbAdvanced is also a hack so it will have plugins. That's why it isn't working. You've disabled the plugins necessary for it to run.

macc 05-06-2009 04:18 PM

that error come after i tried instal this mod

but can not run query to my database - get error ... can you help me ?

Parse error: syntax error, unexpected T_STRING in /home/belapla/public_html/libar/vb/admincp/plugin.php(1995) : eval()'d code on line 6

this error i get when i should import blc_quotes mod.
reg

macc

macc 05-06-2009 04:21 PM

and this database error
Code:

Database error in vBulletin 3.8.2:
Invalid SQL:
ALTER TABLE `quotes` ADD `unapproved` TINYINT( 1 ) NOT NULL;
MySQL Error  : Table 'belapla_libar.quotes' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 6th 2009 @ 01:02:26 PM
Error Date    : Wednesday, May 6th 2009 @ 01:02:26 PM
Script        : http://libar-libar.com/libar/vb/admi...=productimport
Referrer      : http://libar-libar.com/libar/vb/admi...?do=productadd
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.0.67-community


reg
macc

Excalibur82 05-06-2009 05:07 PM

macc: We have already given you resolutions to your database errors. Your errors lie within vBAdvanced, please post on their site with your errors.

macc 05-06-2009 06:29 PM

No, you have wrong - this error come from your product file

Parse error: syntax error, unexpected T_STRING in /home/belapla/public_html/libar/vb/admincp/plugin.php(1995) : eval()'d code on line 6

and database error what i wrote post above ...

when i try unistall your product i get my site down - now is site up but not your product ...

reg

macc

Excalibur82 05-06-2009 07:36 PM

macc: Quit making so many posts in this thread. I know what errors are what and your issue lies with another product, BFC-Quote was not causing your errors, something was preventing my product from adding the tables to your database.

macc 05-06-2009 08:11 PM

Do not joke please - test yourself product file what you attach (this file also give "eval - plugin error " and problem was also when i tried unistall that through my admicp- get database errors and site down -

you should be tested pruduct files before you put here - look in your first post - you forget this and this and that in product file and people get errors ...

all another product files )mods) i can install and no database errors - just with yours -

regards and hope that you will be more serious ...
maybe you should try unistall your product ...

macc

Flowsion 05-06-2009 11:46 PM

I had the same error on installation. Fixed it by doing the following:

[17:47:23] <BullDog> CREATE TABLE `quotes` (
[17:47:23] <BullDog> `id` int(4) NOT NULL auto_increment,
[17:47:23] <BullDog> `quote` mediumtext NOT NULL,
[17:47:23] <BullDog> `username` varchar(255) NOT NULL,
[17:47:23] <BullDog> `unapproved` TINYINT( 1 ) NOT NULL,
[17:47:23] <BullDog> PRIMARY KEY (`id`)
[17:47:23] <BullDog> )

Then got an error for a duplicate entry so:

[17:50:25] <BullDog> ALTER TABLE `quotes` DROP COLUMN `unapproved`

Works fully now. (Remove the time and BullDog and do the query).

Edit:

Am I the only one not able to see usergroup settings or find settings for this thing anywhere?

Flowsion 05-07-2009 12:13 AM

Last question, is there anyway I can import a .txt file to the database?

odln018 05-07-2009 12:25 AM

Excalibur -
Please ignore the less professional members of this forum. They obviously lack some level of propriety.

When you get a second, if you could review my problem I'd appreciate it.

Sincerely,

Excalibur82 05-07-2009 03:27 AM

Flowsion: I'm not seeing why you can't see usergroup perms. You and odln018 can't see usergroups. What version of vB are you running?

odln018: I've dealt with worse, but no biggie. Since you and Flowsion are having the same issue I will try to find out what the problem is.

Excalibur82 05-07-2009 03:31 AM

macc: Make sure you have "OVERWRITE" set to 'YES' as my product are extensively tested before release and I have not gotten those errors at all.

Excalibur82 05-07-2009 03:37 AM

Flowsion & odln018: Import the attached product xml and check usergroups then. Somehow the phrases didn't export with the product.

macc: I do apologize as I found a syntax error on my import product, I have fixed it and it should now properly import and update right.

NOTE: Unfortunately with this update you need to uninstall the product, if you are having issues then let me know and I will give you the code to drop the certain entries and/or tables.

odln018 05-07-2009 09:22 AM

Whoops, I installed it before I got this message.

I'll need that code.

odln018 05-07-2009 11:06 AM

Also, when I try to uninstall the product, I'm getting this:

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:
DROP TABLE `quotes`;

MySQL Error : Unknown table 'quotes'
Error Number : 1051
Request Date : Thursday, May 7th 2009 @ 07:03:00 AM
Error Date : Thursday, May 7th 2009 @ 07:03:01 AM
Script : http://website.com/testforum/admincp/plugin.php
Referrer : http://website.com/testforum/admincp...d=bfc_quote&s=
IP Address : 209.51.16.230
Username : PV
Classname : vB_Database
MySQL Version : 5.1.30-community

odln018 05-07-2009 12:45 PM

I've uninstalled, and tagged this one for future usage.

I'll keep my eye on it until it hits a more stable condition.

Leica.Robbiani 05-07-2009 06:09 PM

Hi,

thanks a lot for the upgrade, now it works with the »'« in the usernames.

One thing I have to check out, the mod doesn't seem working correctly in the »Quote«-section in the usercp. I added a quote, but the usercp ist empty.

Although in the attachment is the german(Du) version of your mod.

Best regards

Leica.Robbiani

Excalibur82 05-07-2009 06:20 PM

Um....is it an actual user that added the quote? If not then it won't display under any username.

Thanks for the german version. If you could keep up with translations then that would be grand.


All times are GMT. The time now is 11:32 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.01347 seconds
  • Memory Usage 1,832KB
  • 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
  • (6)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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