vb.org Archive
Page 99 of 107 « First 49899798 99 100101 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Email Integration (New threads/replies by email) (https://vborg.vbsupport.ru/showthread.php?t=151222)

mykkal 07-08-2009 09:55 PM
Quote:
Originally Posted by Cyricx (Post 1845406)
You'll have to repeat your problem.

The biggest problem people have had is not redoing the file edits after they upgrade vbulletin *sigh*
The problem is where we left it in private messaging. I have reinstalled and followed the upgrade instructions. No matter what I get this error. Can you help me resolve it? A lot of my traffic was based on the email intergration mod and my revenue, etc... is way down now. I'm using php5 and MYSQL 5. The user for SQL has complete access to the database on a dedicated server.

It worked before I attempted this upgrade. Not since tho...

Code:
Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE vb_forum SET
        title_clean = 'Modeling & Acting Auditions (Metro Miami/Ft. Lauderdale & Florida!)',
        title = 'Modeling & Acting Auditions (Metro Miami/Ft. Lauderdale & Florida!)',
        description_clean = 'Castings in Metro Miami , Orlando, Tampa, and the rest of Florida.',
        description = 'Castings in Metro Miami , Orlando, Tampa, and the rest of Florida.',
        link = '',
        displayorder = 60,
        parentid = 3,
        daysprune = -1,
        defaultsortfield = 'lastpost',
        defaultsortorder = 'desc',
        showprivate = 0,
        newpostemail = '',
        newthreademail = '',
        ### Bitfield: vb_forum.options ###
                options = IF(options & 8, options - 8, options),
                options = IF(options & 16, options - 16, options),
                options = IF(options & 32, options - 32, options),
                options = IF(options & 32768, options - 32768, options),
                options = IF(options & 8192, options - 8192, options),
                options = IF(options & 4, options, options + 4),
                options = IF(options & 1, options, options + 1),
                options = IF(options & 2, options, options + 2),
                options = IF(options & 16384, options, options + 16384),
                options = IF(options & 256, options, options + 256),
                options = IF(options & 64, options, options + 64),
                options = IF(options & 128, options, options + 128),
                options = IF(options & 512, options, options + 512),
                options = IF(options & 1024, options, options + 1024),
                options = IF(options & 2048, options, options + 2048),
                options = IF(options & 4096, options, options + 4096),
                options = IF(options & 65536, options, options + 65536),
                options = IF(options & 131072, options - 131072, options),
        styleid = 0,
        imageprefix = '',
        password = '',
        vbseo_moderatepingbacks = 0,
        vbseo_moderatetrackbacks = 0,
        vbseo_moderaterefbacks = 0,
        chiefpost = 1,
        ei_replyaddress = 'atlanta@jobs.mymodeltalk.com',
        ei_hostname = 'mail.mymodeltalk.com',
        ei_username = 'atlanta@jobs.mymodeltalk.com',
        ei_password = 'getmoney',
        ei_folder = 'INBOX',
        ei_connectiontype = '0',
        ei_usergroups = '2',
        ada_forum = 1,
        ada_style = 3
WHERE forumid = 17;

MySQL Error  : Unknown column 'ei_replyaddress' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, May 27th 2009 @ 10:14:41 AM
Error Date    : Wednesday, May 27th 2009 @ 10:14:41 AM
Script        : http://www.mymodeltalk.com/jobs/admi....php?do=update
Referrer      : http://www.mymodeltalk.com/jobs/admi...o=edit&f=17&s=
IP Address    : 76.97.227.84
Username      : mykkal
Classname    : vB_Database
MySQL Version : 5.0.77-community
Code:
Database error in vBulletin 3.8.1
Invalid SQL:

                                SELECT ei_usergroups, title_clean, ei_active
                                FROM vb_forum
                                WHERE forumid = 57;

MySQL Error  : Unknown column 'ei_usergroups' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, May 27th 2009 @ 10:24:10 AM
Error Date    : Wednesday, May 27th 2009 @ 10:24:11 AM
Script        : http://www.mymodeltalk.com/jobs/admincp/usergroup.php?do=update
Referrer      : http://www.mymodeltalk.com/jobs/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    : 76.97.227.84
Username      : mykkal
Classname    : vB_Database
MySQL Version : 5.0.77-community

Cyricx 07-08-2009 10:38 PM
The tone of voice isn't very encouraging for making me want to help, but whatever.

Your missing some fields in your database. I'll run a test of this on the test board and try to duplicate it. The two fields your missing are from version 1.0 and version 2.2, so it makes me think your missing more then just those two.

What version of vbulletin are you running?

mykkal 07-08-2009 11:30 PM
Quote:
Originally Posted by Cyricx (Post 1845437)
The tone of voice isn't very encouraging for making me want to help, but whatever.
What exactly should I sound like after ASKING and WAITING more then 4 months for help when others get it same day?

Especially after I've supported you for more then 3 years.
One second... Did you really say that?

I am running vbulletin version 3.8.

Cyricx 07-09-2009 01:34 PM
I'm completely stumped. I've uninstalled and reinstalled on 3.8.3 and all of the fields are created. Do you use a table prefix?

lbernstein 07-09-2009 04:11 PM
Quote:
Originally Posted by Cyricx (Post 1845301)
Database field overlook. Use phpmyadmin or something similar to go into your database, go into the usergroup table and edit the ei_forumid field to set the character limit to 250. This will be fixed in the next version, or I'll have an alternate way for the system to handle this. Not too happy with how it does it now with typing in IDs. *shrug*
That's great that I can expand it. Do I edit the "char" or the "varchar" variable to expand the character limit to 250?

Thanks again.

Cyricx 07-09-2009 04:21 PM
Nope, varchar type field allows for 250 character limit.

So just edit the number 100 to 250 and that's it.

Fungsten 07-09-2009 06:09 PM
Quote:
Originally Posted by Cyricx (Post 1845864)
Nope, varchar type field allows for 250 character limit.

So just edit the number 100 to 250 and that's it.
Here's what I have for the "ei_forumid":

varchar(100) A pull down menu and a blank line. Where should it be changed?

Cyricx 07-09-2009 06:13 PM
Can you provide a screenshot? I'm unable to determine how to assist you from what you've typed there. It largely depends upon what program your using to interface with your database and the version of that program. Ultimately, you need to edit the field to change the 100 to 250.

Fungsten 07-09-2009 06:23 PM
Quote:
Originally Posted by Cyricx (Post 1845931)
Can you provide a screenshot? I'm unable to determine how to assist you from what you've typed there. It largely depends upon what program your using to interface with your database and the version of that program. Ultimately, you need to edit the field to change the 100 to 250.
This is in phpMyAdmin:

Attachment 101761

Cyricx 07-09-2009 06:35 PM
Your editting the data in the row, not the field itself.

On the left hand dropdown of tables, select "Usergroup", and then click "Structure" in the main screen along the top bar.

Now scroll down and put a checkmark next to ei_forumid and then click the pencil on the bottom.

Attached is a screenshot of the last step.

From there it'll open up to where you can easily change the char limit to 250.


All times are GMT. The time now is 04:02 AM.
Page 99 of 107 « First 49899798 99 100101 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.02166 seconds
  • Memory Usage 1,756KB
  • 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
  • (5)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