NATS3 MySQL Settings

NATS 3 About NATS 3 NATS3 Requirements IPSP Integration NATS3 Changelog For Affiliates Affiliate Link Codes Affiliate Adtools Affiliate Rewards Affiliate Referral Stats Automatic Campaigns Affiliate Billing Info Deep Linking Affiliate Defaults Linkcode ASP Query String NATS3 Main Program Page TubeStudio Adtools Setup Apache Configuration MySQL Settings Creating Admin Accounts File Upload Setup Link Domain NATS3 Files and Directories NATS Go Live Checklist Moving NATS3 Admin Overview Troubleshoot Chart Director Fix Admin Overview Graphs Admin Reports Profit & Loss Report Strack Surfer Stats Chargeback and Credit Amount Inaccuracies Payments Admin Payment Dump Setting Up Pay Vias Hidden Payout Options Temporary Payout Payment Option Webmasterchecks Affiliate Payout Domestic Wire Instant Payments Intercash International Wire Moneybookers RevUpCard NATS Payments PayPal Payment Dump Entry Numbers Payment Dump Variables Payout Scales Epassporte Affiliates Admin Override ID Numbers Account Representatives Affiliate Starting Balance Affiliate Documents Affiliate Start Page Affiliate Referrals Manual Sale Manual Invoice Statistic Query Strings Creating Admin Accounts Affiliate-Specific Join Options Disabled and Banned Affiliates Verifying Account Changes Members Admin MySQL Auth Members Admin Member ID Numbers Expired Members Creating Trial Members Member Delete Member Logging Trial Member Sites Admin Sites Site Setup Configure Redirects ID Numbers Automail Site User Management Username Checking Join Form Errors Free Pre-Initial Checkbox Payouts Based on Program and Join Options Payouts Based on Join Option and Per Option Adding Extra Site Tours Site Partner Join Options Multisite Access Removing Join Options Tour Setup Site Undelete Join Option Box vs Button Redirecting Traffic to a Sponsor Qualified Join Page Hits Type-In Traffic Allowed languages Linkcode Decoding Programs Admin Programs Admin NATS Program Adding Programs ID Numbers Paid Trials Main Program Page Pay Per Click Pay Per Sale Revenue Share Program Default Payouts Referral Payout Tier Third Parties Admin Third Parties Chargeback and Credit Amount Inaccuracies AdultFriendFinder AdultFriendFinderAPI   AdultFriendFinder versus AdultFriendFinderAPI AllMightyContent CamSpot Cams DatingGold EffexMedia Gamelink Jettis International Third-Party Mallcom My Dirty Hobby SexGoesMobile (SGM) Streamate   Streamate Biller versus Third-Party VideoSecrets WebCamClub   WebCamClub with Biller WebCams XonDemand Adtools Admin Adding Adtools Linking to Join and Tour Pages Duplicate Site Adtools Banner Hot-Linking Adding RSS Feeds to NATS's Adtools Downloadable Adtool Bulk Importer Dump Hosted Galleries Hosted Adtool NATS Thumbnails TubeStudio Adtools Admin Billers Admin Biller Cascade NATS Cascades Adding Cascades Biller Cancel Promotions Cascade Weight Autocascade Hidden Cascades Geo-Targeting Cascades Type-In Cascade Post-Biller Templates Extra Biller Fields HTTPS Gateways Payment Deduction Timed Cascade Rules Multiple Biller Accounts Upgrade Plus Adding a Biller   Biller Instructions NATS3 Biller List 123Bill 365Billing 2000Charge Aconti Payment Service Allopass Ampay Argus Authorize.net Bill1st Gateway Billing Line BoaCompra Card Gate Plus CCBill CCBill Direct Pay CCBill Web900 Centrobill ChargeMeLater ClearCard ClearCard IDV Commerce Gate CurePay DHD Media E-Pay Company Edelweiss Card EGatePay ElectraCash EMerchantPay (Interconsult) EnterCharge Epoch EProcessingNetwork EuroBill EPGBill.com FABILLING Global Access GTBill GXBill HeidelPay HeidelPay Gateway iBill ICN Ltd. Infinity Payment Interconsult Jettis Jettis Gateway Jettis International Linkpoint LocalBilling Merchant Partners Gateway Merchant Partners Membership Merchant Solutions MyVirtualCard Netbilling Netbilling Native NetCash Netpay International NoCreditCard Oakbill Optimized Payment System Password by Phone Pay4 Paygea Payment Network Paysite Cash PhoneAccess Plug'n Pay PPPCard Probiller Protx Pure Vanilla RocketGate RocketGate Native RSBilling SafeCharge Secure Billing World SegPay Sonic Bill StandardBill Streamate Symmetrex TrustCash TrustCharge txtNation Ukash Universal Processing Verotel Pro VXSBill WebBilling WebPay WTS WTSeu YNOT Processing Zombaio Netbilling v3 Upgrade Instructions Purchasing Tokens Through Netbilling Streamate Biller versus Third-Party Switching From Epoch to Epoch EU Epoch Member Approval Plus Multiple Biller Accounts Popups Admin Popup Chain Price Cascade Rewards Admin Rewards Admin Reward Points Unshipping Rewards Cross-Sells Admin Cross Sells Admin Process Gateway Cross Sales Outside NATS Outgoing Gateway Cross Sales CCBill Cross-Selling Cross Sells: A to Z Mailing Admin NATS3 Mailing Admin Email Expired Members Repeating Email Member Cancel Emails Member Chargeback Emails Member Credit Emails Member Join Emails Member Rebill Emails Mailer Template Variables Skins & Templates Admin Smarty Plugins Skins Editing Skins Creating Skins Switching Skins Templates nats_code Affiliate Stats Template Affiliate Support Template Affiliate Login Template custom errors.php Template Array Variable Detailed Stats NATS Variables Dialer Statistics Affiliate Signup Post URL Variables Member Usernames & Passwords Output An Affiliate's Last Paid Date Custom Program and Campaign Selection Pages CAPTCHA Removal Username Recommendations Password Retrieval Post-Biller Templates Geo-Target Join Options Template Caching Random Usernames and Passwords Base Templates Protecting Template Data Mail Reseller Signup Template Variable Names Smarty Smarty print array News Section Templating Affiliate Signup Email Getting The NATSCode Checking for Usernames on All Sites Adding Stats to Affiliate Pages Affiliate Join Page Linkcodes   Template Functions nats_apache_note nats_convert_bytes nats_decode nats_encode nats_fhg nats_helper_row_fill nats_get_gateway_token nats_list_campaigns nats_list_programs nats_list_sites nats_my_decode_entities nats_my_encode_entities nats_smarty_function_ajax_box nats_smarty_function_amount_owed nats_smarty_function_gateway_xsell nats_smarty_function_getbonus nats_smarty_function_get_paid_date nats_smarty_rebuild_link nats_smarty_rebuild_query nats_smarty_function_reseller_ajax_box nats_tooltip nats_tour_report nats_wmref_list Template Shortcuts ajax_box amount_owed apache_note convert_bytes fhg gateway_xsell get_loginid_from_campaignid get_gateway_token get_paid_date list_campaigns list_programs list_sites new_gateway_xsell rebuild_link rebuild_query reseller_ajax_box reward_points tooltip tour_report wmref_list Common Parameters assign assign_prefix count data_only display_on_assign start tpl   Helper Functions nats_code nats_extract_program nats_extract_site nats_modify_program nats_modify_site Configuration Admin NATS3 Configuration Options Extra Country Options PayVia Minimum Log Admin Activity IP Address Filtering MEMBER EXPIRE PAD Second Sign-up Matching Affiliate Signup Email GeoIP Fake Upgrade Misc. Admins Database Cleanup Troubleshooting Common Errors Email_Issues Auto Login Emptying Forms AutoLogin Cookie CAPTCHA Changing Licenses Expired License Zend License NATS Extras Remote Affiliate Authentication Shopping Cart Sales Moving Tours, Members' Area, and Galleries Require W-9 Admin Areas Fraud Report NATS Content of the Day Module NATS Load Balancing Module Gallery Builder Module Build Your Own Anything Module NATS Code Wordpress Plugin Error_message_display TMMid

CARMA About CARMA CARMA Requirements CARMA Changelog Setup Setting Up CARMA MySQL Settings Add Site Porting Sites to CARMA Moving CARMA Sites Admin The Sites Admin Site Sections Publish Mode Content Set Schedule Templates Admin Members Area Templates Tour Templates Member Favorites Smarty Loops Smarty Caching Smarty print array Base Templates User Variables Rating System   Template Functions CARMA Template Functions carma_actor_photo_name carma_comments_display carma_comments_form carma_count carma_favorite carma_gal_custom carma_get_extended carma_list carma_list_favorites carma_list_gals carma_list_third_party_content carma_list_videos carma_login_log carma_most_viewed carma_newest carma_news carma_poll carma_retrieve_sections carma_search carma_actors_search carma_show_gal carma_show_video carma_top_actors carma_top_rated carma_upcoming print_page_numbers Template Function Aliases carma_comment_display carma_display_comment carma_display_comments carma_extended carma_extended_data carma_get_extended_data carma_list_all Common Parameters assign assign_prefix count data_only display_on_assign start tpl Schedule Admin The Schedule Admin Scheduling Content Content Set Schedule Calendar Snapshot News Admin The News Admin Add News Auto News Feedback Admin The Feedback Admin The Polls Admin Gallery Content Admin The Gallery Content Admin Adding Content Edit Image Adding Image Text Content Set Locations Content Set Categories Managing Thumbnails Watermarking Image Removal Image Order Rotate Image Image Quality Video Content Admin The Video Content Admin Adding Content Video Clips Out of Order Video Thumbnails Content Set Locations Content Set Categories Video Format Flash Player Generate Flash Videos Using mp4 Videos Video Content Names Thumbnails Admin The Thumbnails Admin Image Thumbnail Video Thumbnails Third Parties Admin Third Party Content Scan Content Admin Scan Content Actors Admin The Actors Admin Add Actor Actor Photos Actor Documents Manage Attribute Types Creating Actor Pages Members Admin The Members Admin Member Details Stats Admin The Stats Admin Site Statistics Member's Statistics Content Statistics Actor's Statistics Accounts Admin Accounts Admin Add Account Access Levels Configuration Admin The Configuration Admin CARMA Configuration Variables Video Format Troubleshooting Common Errors Extras The Support Admin Admin Areas CARMA Home Pseudo Streaming Flash Player Using mp4 Videos Zipping Content Third Party Content X-Sendfile Xmoov-php TMMid

RSSdish Setup RSSDish Requirements MySQL Settings Feed Basics Adding Feeds New Feed Viewing RSSDish Feeds Advanced Feeds RSSDish HTML Templates RSSDish Account Types Feed Validation NATS Affiliate Info in RSSDish Adding RSS Feeds for NATS's Free Hosted Galleries

MySQL Server 5.x Requirement Information

Present versions of NATS3, RSSdish, and CARMA do not require MySQL 5 or greater yet, but in the near future, Too Much Media will require all NATS, RSSdish, and CARMA clients to upgrade to MySQL Server 5 or greater. MySQL 5.0 offers many improved and additional features that future software versions will use.

Important Settings and Features

The following settings ensuring your Too Much Media product works correctly:

MySQL server modes are almost all mutually exclusive, so setting one MySQL mode disables all other modes. MySQL Server has three different places to change settings: the my.cnf file (MySQL configuration file), the start-up switches, and the current session settings (both globally and for individual sessions).

NO_UNSIGNED_SUBTRACTION

Failure to turn ON unsigned subtraction causes potential problems with financial calculations. It makes absurdly large numbers appear in place of fairly small numbers.

STRICT MODE

Strict mode must be disabled for any Too Much Media product to function correctly. If any of the following modes are enabled, they must be disabled or removed: TRADITIONAL, STRICT_ALL_TABLES, or STRICT_TRANS_TABLES. These settings alter how MySQL handles default data types and null field values, which can adversely affect normal operation. As stated above for NO_UNSIGNED_SUBTRACTION, if you remove any pre-existing strict mode settings and make sure that NO_UNSIGNED_SUBTRACTION is set.

You can check your current MySQL server mode by connecting to the MySQL database and running the following queries:

     SELECT @@global.sql_mode;
     SELECT @@session.sql_mode;

Please Note: Too Much Media does not configure or support MySQL. Any issues related to repairing, installing, or configuring any server related component must be directed to your Host, Server Admin, or Server Technician.

Database Copy Errors

The following error, which sometimes occur when you copy your NATS database from one server to another, means you didn't escape the MySQL reserved word, cascade:

ERROR 1064 at line 678: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'cascade char(16) NOT NULL default '', siteid int(10) unsigned

Escape the word cascade with a high comma (`) in the SQL query. Note: the high comma is also called a back-tic, and on US keyboards, it is usually left of the number 1 key.