Announcement

Collapse
No announcement yet.

Error message upon adding subscription

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error message upon adding subscription

    Hi guys,

    I just recently moved to a dedicated server and, until now, have had no issues with my subscription services. I tried to add a manual subsctiption and got the following error. Can someone tell me what this might mean or how I can fix it? I am a newbie when it comes to database errors and such.

    Database error in vBulletin 3.6.4:

    Invalid SQL:

    SELECT text, languageid, special
    FROM phrase AS phrase
    LEFT JOIN phrasetype USING (fieldname)
    WHERE phrase.fieldname = ''
    AND varname = '' AND languageid IN (-1, 0, 1);

    MySQL Error :
    Error Number :
    Date : Tuesday, March 6th 2007 @ 12:39:05 PM
    Script : http://*****/forum/admincp/subscriptions.php?do=status
    Referrer : http://*****/forum/admincp/subscriptions.php?do=adjust&userid=1123
    IP Address : **.**.***.**
    Username : Sherry
    Classname : vb_database

  • #2
    Is that the complete error? There is usually more info than that.

    Try running Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Sorry Steve,

      The above error was what was emailed to me.

      I tried running the repair/optimize utility but the problem still exists. Here is the message received.


      Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657

      Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657

      Warning: mysql_query(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 363

      Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 837

      Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 855

      Comment


      • #4
        Looks like a server problem. Which versions of PHP and MySQL?
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          According to my control panel I am running PHP 4.4.5 and MySQL 5.0.24-standard.

          Comment


          • #6
            First, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version:

            Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

            [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

            Next, disable all plugins.

            Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

            define('DISABLE_HOOKS', true);

            Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Okay, I will try this.

              Comment


              • #8
                I have re-installed all of the vb-non image files and have run the diagnostics/suspect file versions. Here is what I get:

                Documentation.html File not recognized as part of vBulletin
                Documentation.txt File not recognized as part of vBulletin
                browse_foreigners.php File not recognized as part of vBulletin
                changelog.php File not recognized as part of vBulletin
                chk_rel.php File not recognized as part of vBulletin
                config.default.php File not recognized as part of vBulletin
                config.footer.inc.php File not recognized as part of vBulletin
                config.header.inc.php File not recognized as part of vBulletin
                config.inc.php File not recognized as part of vBulletin
                db_create.php File not recognized as part of vBulletin
                db_datadict.php File not recognized as part of vBulletin
                db_details.php File not recognized as part of vBulletin
                db_details_common.php File not recognized as part of vBulletin
                db_details_db_info.php File not recognized as part of vBulletin
                db_details_export.php File not recognized as part of vBulletin
                db_details_importdocsql.php File not recognized as part of vBulletin
                db_details_links.php File not recognized as part of vBulletin
                db_details_qbe.php File not recognized as part of vBulletin
                db_details_structure.php File not recognized as part of vBulletin
                db_operations.php File not recognized as part of vBulletin
                db_printview.php File not recognized as part of vBulletin
                db_search.php File not recognized as part of vBulletin
                docs.css File not recognized as part of vBulletin
                export.php File not recognized as part of vBulletin
                footer.inc.php File not recognized as part of vBulletin
                forumpath.php File not recognized as part of vBulletin
                geo_header.php File not recognized as part of vBulletin
                header.inc.php File not recognized as part of vBulletin
                header_printview.inc.php File not recognized as part of vBulletin
                ldi_check.php File not recognized as part of vBulletin
                ldi_table.php File not recognized as part of vBulletin
                left.php File not recognized as part of vBulletin
                local_links.php File not recognized as part of vBulletin
                local_links_actions.php File not recognized as part of vBulletin
                local_links_admin.php File not recognized as part of vBulletin
                local_links_ajax.php File not recognized as part of vBulletin
                local_links_search.php File not recognized as part of vBulletin
                local_resize.php File not recognized as part of vBulletin
                local_stream.php File not recognized as part of vBulletin
                main.php File not recognized as part of vBulletin
                mult_submits.inc.php File not recognized as part of vBulletin
                pdf_pages.php File not recognized as part of vBulletin
                pdf_schema.php File not recognized as part of vBulletin
                phpinfo.php File not recognized as part of vBulletin
                queryframe.php File not recognized as part of vBulletin
                querywindow.php File not recognized as part of vBulletin
                read_dump.php File not recognized as part of vBulletin
                server_binlog.php File not recognized as part of vBulletin
                server_collations.php File not recognized as part of vBulletin
                server_common.inc.php File not recognized as part of vBulletin
                server_databases.php File not recognized as part of vBulletin
                server_engines.php File not recognized as part of vBulletin
                server_export.php File not recognized as part of vBulletin
                server_links.inc.php File not recognized as part of vBulletin
                server_privileges.php File not recognized as part of vBulletin
                server_processlist.php File not recognized as part of vBulletin
                server_status.php File not recognized as part of vBulletin
                server_variables.php File not recognized as part of vBulletin
                sql.php File not recognized as part of vBulletin
                tbl_addfield.php File not recognized as part of vBulletin
                tbl_alter.php File not recognized as part of vBulletin
                tbl_change.php File not recognized as part of vBulletin
                tbl_create.php File not recognized as part of vBulletin
                tbl_indexes.php File not recognized as part of vBulletin
                tbl_move_copy.php File not recognized as part of vBulletin
                tbl_printview.php File not recognized as part of vBulletin
                tbl_properties.inc.php File not recognized as part of vBulletin
                tbl_properties.php File not recognized as part of vBulletin
                tbl_properties_common.php File not recognized as part of vBulletin
                tbl_properties_export.php File not recognized as part of vBulletin
                tbl_properties_links.php File not recognized as part of vBulletin
                tbl_properties_operations.php File not recognized as part of vBulletin
                tbl_properties_structure.php File not recognized as part of vBulletin
                tbl_properties_table_info.php File not recognized as part of vBulletin
                tbl_query_box.php File not recognized as part of vBulletin
                tbl_relation.php File not recognized as part of vBulletin
                tbl_rename.php File not recognized as part of vBulletin
                tbl_replace.php File not recognized as part of vBulletin
                tbl_replace_fields.php File not recognized as part of vBulletin
                tbl_row_action.php File not recognized as part of vBulletin
                tbl_select.php File not recognized as part of vBulletin
                themes.php File not recognized as part of vBulletin
                transformation_wrapper.php File not recognized as part of vBulletin
                translators.html File not recognized as part of vBulletin
                user_password.php File not recognized as part of vBulletin
                vbshout.php File not recognized as part of vBulletin
                Scanned 51 files./admincp
                admin_custom_links.php File not recognized as part of vBulletin
                moderator.php File not found
                vba_cmps_admin.php File not recognized as part of vBulletin
                Scanned 3 files./archive
                Scanned 30 files./clientscript
                ldm_ajax_doisugg.js File not recognized as part of vBulletin
                ldm_ajax_keysugg.js File not recognized as part of vBulletin
                Scanned 102 files./includes
                adminfunctions_vba_cmps.php File not recognized as part of vBulletin
                functions_digest.php File does not contain expected contents
                functions_editor.php File not found
                local_links_admininclude.php File not recognized as part of vBulletin
                local_links_include.php File not recognized as part of vBulletin
                local_links_init.php File not recognized as part of vBulletin
                local_links_misc.php File not recognized as part of vBulletin
                local_links_resize.php File not recognized as part of vBulletin
                reminder.php File not recognized as part of vBulletin
                vba_cmps_include_bottom.php File not recognized as part of vBulletin
                vba_cmps_include_error.php File not recognized as part of vBulletin
                vba_cmps_include_template.php File not recognized as part of vBulletin
                vba_cmps_include_top.php File not recognized as part of vBulletin
                vba_cmps_plugin_newpost.php File not recognized as part of vBulletin
                Scanned 20 files./includes/cron
                gallery.php File not recognized as part of vBulletin
                privateattachments.php File not recognized as part of vBulletin
                Scanned 8 files./includes/paymentapi
                Scanned 11 files./includes/xml
                bitfield_pma.xml File not recognized as part of vBulletin
                cpnav_vbacmps.xml File not recognized as part of vBulletin
                cpnav_xlinks.xml File not recognized as part of vBulletin
                hooks_ldm.xml File not recognized as part of vBulletin
                Scanned 66 files./install
                Scanned 11 files./modcp
                cpms_coms_block.php File not recognized as part of vBulletin

                Comment


                • #9
                  If you are still getting this error then move or delete these non-vB files:

                  bitfield_pma.xml File not recognized as part of vBulletin
                  cpnav_vbacmps.xml File not recognized as part of vBulletin
                  cpnav_xlinks.xml File not recognized as part of vBulletin
                  hooks_ldm.xml File not recognized as part of vBulletin
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment


                  • #10
                    Hi Steve,

                    I moved these files but am still getting the error

                    Comment


                    • #11
                      If you have disaled or removed all plugins, fill out a support ticket at:

                      http://members.vbulletin.com/members...ontactform.php

                      Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.
                      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                      Change CKEditor Colors to Match Style (for 4.1.4 and above)

                      Steve Machol Photography


                      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                      Comment


                      • #12
                        Thanks Steve. This issue is now resolved

                        Comment


                        • #13
                          Very curious to know what the resolution was. Thanks!
                          AKA "ChurchMedia"
                          CMN.NU

                          Comment


                          • #14
                            I found my problem -- it was the Send PM/Email On Paid Subscription (product-sendpmonpaidsubscription-premium.xml) hack by Paul41598.
                            AKA "ChurchMedia"
                            CMN.NU

                            Comment

                            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                            Working...
                            X