vb.org Archive
Page 51 of 62 « First 414950 51 525361 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)
-   -   vBSupport v2.0.0 Beta 2 (https://vborg.vbsupport.ru/showthread.php?t=94023)

JamieLee2k 01-28-2007 04:40 PM
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM _vbvbs_ticket_post AS post
LEFT JOIN _vbuser AS user ON(user.userid = post.userid)
LEFT JOIN _vbuserfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN _vbusertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN _vbavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN _vbcustomavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN _vbreputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,27)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Sunday, January 28th 2007 @ 01:39:19 PM
Script : http://www.xleagues.net/forum/vbsupp...wthread&tid=19
Referrer : http://www.xleagues.net/forum/vbsupport.php
IP Address : xx.xx.xx.xx
Username : JamieLee2k
Classname : vb_database

This was fine before and now something changed it

sinisterpain 01-28-2007 11:23 PM
If you refer to the edits I supplied. I did not change anything more than adding the ability to read the datastore properly and one phrase add. All other info is the authors.
Are you using table prefix?

Code:
FROM _vbvbs_ticket_post AS post
LEFT JOIN _vbuser AS user ON(user.userid = post.userid)
LEFT JOIN _vbuserfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN _vbusertextfield AS usertextfield ON(usertextfield.userid = user.userid)
The code should not look like that

nymyth 01-29-2007 02:51 PM
sinister...i downloaded your version, but i still cannot see the categorys....any ideas?

if it turn off the option of categorys...and submit an issue, i get this error before the redirect:

Quote:
Warning: Invalid argument supplied for foreach() in /vbsupport.php on line 398
and after the redirect the following....I AM NOT USING TABLE PREFIXES....

Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,1)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Monday, January 29th 2007 @ 11:53:37 AM
Script : http://www.fsenyc.com/forum/vbsuppor...ewthread&tid=1
Referrer : http://www.fsenyc.com/forum/vbsupport.php
IP Address : xxx.xx.xx.xxx
Username : nymyth
Classname : vb_database
Peace

sinisterpain 01-29-2007 07:29 PM
Check you vbsupport.php file and tell me if it looks like this:

Code:
// build the $emailids
    $vbulletin->datastore->do_db_fetch("'vbs_category'");
    $pmids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminpmusers']);
    $vbulletin->datastore->do_db_fetch("'vbs_category'");
    $emailids = explode(',', $vbulletin->vbs_category["$categoryid"]['adminemailusers']);

    // check for email notifications
    if (is_array($emailids) && is_array($pmids))
    {
      // process add admins
      $vbulletin->datastore->do_db_fetch("'vbs_admin'");
      foreach($vbulletin->vbs_admin AS $userid => $user)
      {
Also have you tryed to install without my edits first.

nymyth 01-29-2007 08:18 PM
yeah it looks the same....i havent tried without the edits, seeing im running 3.6.4

Peace

nymyth 01-29-2007 08:26 PM
when i installed the original one i see the categorys fine, however when submitting the ticket i now get this
Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,1)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Monday, January 29th 2007 @ 05:24:24 PM
Script : http://www.fsenyc.com/forum/vbsuppor...ewthread&tid=1
Referrer : http://www.fsenyc.com/forum/vbsupport.php?do=newthread
IP Address : xx.xxx.xx.xxx
Username : nymyth
Classname : vb_database
Peace

nymyth 01-29-2007 08:30 PM
OK NEVERMIND...lol...i ran this query
Quote:
ALTER TABLE user ADD level INT UNSIGNED NOT NULL DEFAULT '0'
with the original install and it works fine now....hmmmm...thanks anyway

Peace

fib 02-03-2007 03:01 PM
Quote:
Originally Posted by sinisterpain (Post 1166692)
Ok since I have been recieving pms regards to this hack, and there has been confusion over the file edits to make. I have decided to upload the package with all the edits I have made to date. Please be sure that you read the included "readme file edits.txt". There are still issues with this hack in 3.6.4 but with the edits this should provide most admins with what they want to use the system for. I can not guarentee this will work for everyone, but it works on my 3.6.4 forum. Good luck!:D
I wanted to say thankyou for all your work as I thought everything was looking great

but I am afraid on testing I do have an issue or 2

Looking in the DB all seems well the 3 tables are there and are accepting messages etc
the install has been done as per your download above

I followed all and all seems great but when I list the messages I get "there were no tickets found" for open, closed and list any.
this is as a registered user who has submitted tickets and for the admin. The "your Ticket Information" is correct and updates if I change the ticket in the DB to closed. Admin can only see the number of the tickets admin has submitted not the others needing replied to.

Am I missing an obvious marker?

thank you for your time we all appreciate it.

sinisterpain 02-04-2007 01:20 PM
Quote:
Originally Posted by fib (Post 1173700)
I wanted to say thankyou for all your work as I thought everything was looking great

but I am afraid on testing I do have an issue or 2

Looking in the DB all seems well the 3 tables are there and are accepting messages etc
the install has been done as per your download above

I followed all and all seems great but when I list the messages I get "there were no tickets found" for open, closed and list any.
this is as a registered user who has submitted tickets and for the admin. The "your Ticket Information" is correct and updates if I change the ticket in the DB to closed. Admin can only see the number of the tickets admin has submitted not the others needing replied to.

Am I missing an obvious marker?

thank you for your time we all appreciate it.
Make sure that you make the template edits as per the author except the navbar, make sure that the permisions are set for each user group both in the support catergories that you add and the usergroups in the admincp.

fib 02-04-2007 05:20 PM
this is great although I was going to use the system for unregistered aswell and do not seem to be able to get that to work -
I suppose it would need to ask for an email address too.

The only other thing (I hope) is that my forum is 800 wide and the create new ticket / reply is pushed off the main block by the menu on the left. Is there any way to overcome this

maybe move the menu to be above rather than at the side? Where would I find this in a template as I may look at this myself.

thank you:)
I appreciate your help


All times are GMT. The time now is 06:15 AM.
Page 51 of 62 « First 414950 51 525361 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.02210 seconds
  • Memory Usage 1,763KB
  • 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