DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin



DragonByte Tech Proudly Hosted By Hivelocity.net
Cloud Servers from HiVelocity Hosting / Sparknode

View Issue Info: Database error on Creating a new mailing list

Category:
Bug
Status:
Not A Bug
Priority:
N/A
Product Version:
Enter the product version you are running in the following format: x.y.x
Example: 1.1.0
1.1.6
Forum Version:
Enter the forum version you are running.
vBulletin 4.2.0
Browser:
Enter the browser(s) and version(s) you encounter this issue on.
Firefox Aurora 15.0a2
Default Skin?
Does this issue happen on the default skin?
Yes
Support Agent:
Belazor

User Tag List

  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Depressed
  • Down
  • Drunk
  • Embarrased
  • Enraged
  • Friendly
  • Geeky
  • Godly
  • Happy
  • Hateful
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Poorly
  • Sad
  • Secret
  • Shy
  • Sneaky
  • Tired
  • Wtf
  • Results 1 to 6 of 6

    Thread: Database error on Creating a new mailing list


    Forum: vBMail Lite Support

    Questions & Answers for vBMail.
    Click here to buy!

    1. #1
      Junior Member
      Level 6 (3,554 Loyalty Points)
      This user has no status.
       
      I am:
      ----
       

      Gil
      141 (0 Banked)
      Total Contributions For

      KiwiNeil      $ 0.00
      User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
      Join Date
      Apr 2012
      Posts
      9
      Points
      141
      Credits
      29
      Problems Posted
      0
      Problems Solved
      0
      Best Answers
      0
      Good Answers
      0
      Rep Power
      0

      Default Database error on Creating a new mailing list

      On attempting to set up my first mailing list I got this database error. What do I do to fix the issue?

      Thanks in advance!


      Database error in vBulletin 4.2.0:

      Invalid SQL:
      INSERT INTO dbtech_vbmail_mailinglist
      (title, description, active, displayorder, ownerid, fromemail, external, permissions)
      VALUES
      ('Mailing List', 'A mailing list that notifies people of wonderous things.', '1', 10, 0, 'forum@myforum.com', '0', 'a:27:{i:4;i:0;i:6;i:94;i:8;i:0;i:28;i:0;i:21;i:0; i:26;i:0;i:37;i:0;i:11;i:0;i:23;i:0;i:9;i:0;i:10;i :0;i:12;i:0;i:7;i:0;i:32;i:0;i:27;i:0;i:38;i:0;i:3 1;i:0;i:33;i:0;i:2;i:0;i:35;i:0;i:34;i:0;i:5;i:0;i :29;i:0;i:36;i:0;i:1;i:0;i:3;i:0;i:25;i:0;}');

      MySQL Error : Unknown column 'external' in 'field list'
      Error Number : 1054
      Request Date : Saturday, July 14th 2012 @ 02:46:41 PM
      Error Date : Saturday, July 14th 2012 @ 02:46:41 PM
      Script : http://www.myforum.com/forum/admincp...do=mailinglist
      Referrer : http://www.myforum.com/forum/admincp...do=mailinglist
      IP Address : xx.xxx.xx.xx
      Username : Admin1234
      Classname : vB_Database
      MySQL Version : 5.5.24-percona-sure1-log

    2. #2
      Founder
      Level 5 (3,164 Loyalty Points)
      is finally done working on vBShop
      for now xD
       
      I am:
      Sneaky
       
      Belazor's Avatar
      Gil
      55,682 (460,361 Banked)
      Total Contributions For

      Belazor Points (Total)      $ 0.00
      User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
      Join Date
      Dec 2009
      Location
      Glasgow, Scotland
      Age
      26
      Posts
      12,208
      Blog Entries
      13
      Points
      55,682
      Credits
      144,394
      Problems Posted
      0
      Problems Solved
      3
      Best Answers
      0
      Good Answers
      2
      Rep Power
      10

      Default

      Certain MySQL configs had issues with the way I added that column.

      Code:
      alter table dbtech_vbmail_mailinglist add external enum('0', '1') not null default '0'
      should fix it
      Fillip Hannisdal
      Founder & Programming Director
      DragonByte Technologies http://www.DragonByte-Tech.com


      Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
      Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
      Please do not Private Message Decado with support requests or forum errors.

      When I say "Hotfix Released" it means you should re-download the product and re-upload the files.

    3. #3
      Junior Member
      Level 6 (3,554 Loyalty Points)
      This user has no status.
       
      I am:
      ----
       

      Gil
      141 (0 Banked)
      Total Contributions For

      KiwiNeil      $ 0.00
      User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
      Join Date
      Apr 2012
      Posts
      9
      Points
      141
      Credits
      29
      Problems Posted
      0
      Problems Solved
      0
      Best Answers
      0
      Good Answers
      0
      Rep Power
      0

      Default

      That was very quick service. Thanks!

    4. #4
      Junior Member
      Level 6 (3,554 Loyalty Points)
      This user has no status.
       
      I am:
      ----
       

      Gil
      141 (0 Banked)
      Total Contributions For

      KiwiNeil      $ 0.00
      User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
      Join Date
      Apr 2012
      Posts
      9
      Points
      141
      Credits
      29
      Problems Posted
      0
      Problems Solved
      0
      Best Answers
      0
      Good Answers
      0
      Rep Power
      0

      Default

      When I did that I got this database error:

      Database error in vBulletin 4.2.0:

      Invalid SQL:

      INSERT IGNORE INTO dbtech_vbmail_subscription
      (userid, mailinglistid)
      (
      SELECT userid, 1 AS mailinglistid
      FROM user AS user
      WHERE (
      FIND_IN_SET(6, membergroupids)
      OR usergroupid IN(6)
      )
      AND user.dbtech_vbmail_bounceflag = '0'
      );

      MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
      Error Number : 1054
      Request Date : Saturday, July 14th 2012 @ 03:38:20 PM
      Error Date : Saturday, July 14th 2012 @ 03:38:20 PM
      Script : http://www.myforum.com/forum/admincp...do=mailinglist
      Referrer : http://www.myforum.com/forum/admincp...do=mailinglist
      IP Address : xx.xxx.xx.xxx
      Username : admin1234
      Classname : vB_Database
      MySQL Version :

      and then when it appears the chron job did its work I received notice of another database error. It is:

      Database error in vBulletin 4.2.0:

      Invalid SQL:

      SELECT
      user.userid,
      user.username,
      user.email,
      user.usergroupid,
      user.membergroupids,
      user.infractiongroupid,
      user.displaygroupid
      FROM `dbtech_vbmail_message` AS dbtech_vbmail_message
      INNER JOIN user AS user ON(user.email = dbtech_vbmail_message.fromaddress)
      WHERE dbtech_vbmail_message.fromaddress != ''
      AND dbtech_vbmail_message.bounce = '1'
      AND user.dbtech_vbmail_bounceflag = '0'
      GROUP BY dbtech_vbmail_message.fromaddress
      HAVING COUNT(*) >= 5;

      MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
      Error Number : 1054
      Request Date : Saturday, July 14th 2012 @ 03:45:24 PM
      Error Date : Saturday, July 14th 2012 @ 03:45:24 PM
      Script : http://www.myforum.com/forum/cron.php?rand=1342295123
      Referrer : http://www.myforum.com/forum/forum.php
      IP Address : xx.xxx.xx.xxx
      Username : Unregistered
      Classname : vB_Database
      MySQL Version :

      Is there anything else I should do to fix the issues?

    5. #5
      Founder
      Level 5 (3,164 Loyalty Points)
      is finally done working on vBShop
      for now xD
       
      I am:
      Sneaky
       
      Belazor's Avatar
      Gil
      55,682 (460,361 Banked)
      Total Contributions For

      Belazor Points (Total)      $ 0.00
      User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
      Join Date
      Dec 2009
      Location
      Glasgow, Scotland
      Age
      26
      Posts
      12,208
      Blog Entries
      13
      Points
      55,682
      Credits
      144,394
      Problems Posted
      0
      Problems Solved
      3
      Best Answers
      0
      Good Answers
      2
      Rep Power
      10

      Default

      Code:
      alter table user add dbtech_vbmail_bounceflag enum('0', '1') not null default '0'
      Fillip Hannisdal
      Founder & Programming Director
      DragonByte Technologies http://www.DragonByte-Tech.com


      Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
      Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
      Please do not Private Message Decado with support requests or forum errors.

      When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
      Thanks KiwiNeil thanked for this post

    6. #6
      Junior Member
      Level 6 (3,554 Loyalty Points)
      This user has no status.
       
      I am:
      ----
       

      Gil
      141 (0 Banked)
      Total Contributions For

      KiwiNeil      $ 0.00
      User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
      Join Date
      Apr 2012
      Posts
      9
      Points
      141
      Credits
      29
      Problems Posted
      0
      Problems Solved
      0
      Best Answers
      0
      Good Answers
      0
      Rep Power
      0

      Default

      All sorted. Thanks!

    Thread Information

    Users Browsing this Thread

    There are currently 1 users browsing this thread. (0 members and 1 guests)

    Similar Threads

    1. [vB 3.8.x] Creating a new mailing list gives this error
      By Jona in forum vBMail Lite Support
      Replies: 6
      Last Post: 10th May 2012, 16:05

    Tags for this Thread

    Bookmarks

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •