vb.org Archive
Page 20 of 25 « First 101819 20 2122 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Yet Another Awards System [1.2.1] (https://vborg.vbsupport.ru/showthread.php?t=78934)

Neal-UK 07-14-2005 11:28 PM
Quote:
Originally Posted by jluerken
Hi author,

I found a bug in the request award section.

I am using table prefixes in my installation and request_award is not taking care about this.

Everytime a user requests an award I get this db error:

PHP Code:
Database error in vBulletin 3.0.7:
 
Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'88856','CFN|LordSoth Award Request Form','CFN|LordSoth','4','1117187527','Award Request Form - CFN|LordSoth
 
------------------
Sender Information
 
UserID: 4
Username: CFN|LordSoth
Fullname: CFN|LordSoth
 
-----------------------------
Request Information:
Award ID: 3
Award Name: Donationaward
Award Description: Thanks for your donation
[img]http://www.clanforums.com/forum/images/medals/contributoraward.gif[/img]
 
Recipient username : Toky 
 
-----------------------------------------------------
Please explain why the listed recipient should receive the award.
 
Sponsoring
-----------------------------------------------------
','1','1','0','0','1')
mysql error: Table 'usr_web1_3.post' doesn't exist
 
mysql error number: 1146 
The table name is not usr_web1_3.post, its usr_web1_3.vb3_post where vb3_ is the prefix


The error is in request_award.php around line 40
And line 41 has the same error. It should be:
PHP Code:
UPDATE " . TABLE_PREFIX . "thread SET 
I've just had to edit this template in about 8 places to put my db prefix in as i have FORUM before the name.

Is this the mod I only need to do or will other things need to be adjusted to get it working 100%? Don't want new errors on a newly re-installed forum and db.

biagrin 07-17-2005 01:06 PM
im getting the following error:

PHP Code:
Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'22280','biagrin Award Request Form','biagrin','1','1121608524','[b]Award Request Form - biagrin[/b]

------------------
[color=blue][b]Sender Information[/b][/color]

UserID: [url=http://www.socialoutkast.com/forum/member.php?u=1]1[/url]
Username: biagrin
Fullname: biagrin

-----------------------------
[color=red][b]Request Information:[/b][/color]
Award ID: [b][url=http://www.socialoutkast.com/forum/awards.php#award1]1[/url][/b]
Award Name: [b]test[/b]
Award Description: [b]testing awards[/b]
[url=http://www.socialoutkast.com/forum/awards.php#award1][img]https://vborg.vbsupport.ru/external/2005/07/4.gif[/img][/url]

Recipient username : [b][url=http://www.socialoutkast.com/forum/member.php?username=biagrin] biagrin [/url] [/b]

-----------------------------------------------------
Please explain why the listed recipient should receive the award.

test
-----------------------------------------------------
','1','1','0','0','1')
mysql error: Table 'socitvkx_general.post' doesn't exist

mysql error number: 1146

Date: Sunday 17th of July 2005 02:55:24 PM
Script: [url]http://www.socialoutkast.com/forum/request_award.php[/url]
Referer: biagrin
Username: biagrin
IP Address: **.**.**.** 

have i done something wrong somewhere?

any help would be appreciated :)

SmartGnome 07-18-2005 08:30 PM
I have clicked install :banana:

Thanks for sharing

disquiet 07-19-2005 12:23 PM
I got the same error that jluerken and biagrin are getting, but by deslecting the option to write to a thread in the config page, I got rid of that... So I kinda worked my way around that one...

Plus I'm getting an error when I click on the link to the categories while viewing the Awards page itself... I'm getting this error...
Code:
Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM vb3_award_cat
                WHERE award_cat.award_cat_id = 1
                        ORDER BY award_cat_displayorder
               
mysql error: Unknown table 'award_cat' in where clause

mysql error number: 1109
In reading this thread, I've seen that this is a problem with the prefixes in my db, but I don't know how to rectify the situation. I have the latest dl from the first post, so no other prefix fixes have worked... Any help would be appreciated...

*EDIT*
I guess you can ignore the above problems... I am still having them, but I have fiddled with the templates and managed to hide the error causing links...now unless I add the code back into the templates, no one will get the errors...

Once again, thanks for the hack...too bad for all the bugs that I had though...but still great..

*Me clicks install*
*/EDIT*

biagrin 07-20-2005 01:13 AM
exact same problem here mate

Code:
Database error in vBulletin 3.0.7:

Invalid SQL: SELECT * FROM socitvkx_award_cat
                WHERE award_cat.award_cat_id = 1
                        ORDER BY award_cat_displayorder
               
mysql error: Unknown table 'award_cat' in where clause

mysql error number: 1109

Date: Wednesday 20th of July 2005 03:10:03 AM
Script: http://www.socialoutkast.com/forum/awards.php?award_cat_id=1
Referer:
Username: biagrin
IP Address: ***********
i manged to fix the previous problem and now i cant remember what i done. ill have a look and get back to you

oman 07-25-2005 04:07 PM
Hi

can u upgrade this hack for 3.5.0 plz

thanx

FusionHosting 08-04-2005 05:52 AM
Anyone have this working in 3.08? I tried the upgrade and now it seems the award hack is broken, also had a user say they couldn't post in a private forum.

jluerken 08-04-2005 07:17 AM
Quote:
Originally Posted by FusionHosting
Anyone have this working in 3.08? I tried the upgrade and now it seems the award hack is broken, also had a user say they couldn't post in a private forum.
I'm running it with 3.0.8. Simply check if all file changes are still correct and then run award_install.php again to setup the templates again.

This should fix your problem

Bernd 08-04-2005 01:04 PM
Where can i change the css styles for the additional table displayed in memberlist.php?
The "awards" table is currently grey and would like to adjust it to fit my template.

cuphongle 08-04-2005 04:01 PM
yea i got it workiong on 3.0.8,
but i dont know how to change the award_request...
can someone help me a little?


All times are GMT. The time now is 10:16 PM.
Page 20 of 25 « First 101819 20 2122 Last »
Show 40 post(s) from this thread on one page

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.04901 seconds
  • Memory Usage 1,769KB
  • 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
  • (3)bbcode_php_printable
  • (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