Results 1 to 4 of 4

Thread: Moved site to new server, problems with CMPS edit page

  1. #1
    Join Date
    Apr 2005
    Posts
    290

    Default Moved site to new server, problems with CMPS edit page

    I am testing the move of my site to a new server. I moved everything to a new server which is running MySQL 5 instead of 4.x. I seem to be having problems making changes to my default page in the CMPS admincp area.

    When I try to enable the display of a module in the Edit Page area (my default page), I receive the following error:

    Code:
    Database error in vBulletin 3.6.0:
    
    Invalid SQL:
    UPDATE adv_pages SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    	`title` = 'Default / Homepage',
    	`displayorder` = '0',
    	`parentid` = '0',
    	`styleid` = '-1',
    	`active` = '1',
    	`type` = 'module',
    	`name` = 'home',
    	`meta` = (removed)
    	`advanced` = 'a:2:{s:15:\"adv_portal_poll\";a:1:{s:19:\"portal_poll_forumid\";s:1:\"4\";}s:15:\"adv_portal_news\";a:7:{s:19:\"portal_news_forumid\";s:1:\"9\";s:20:\"portal_news_maxposts\";s:1:\"1\";s:24:\"portal_news_allowreplies\";s:1:\"0\";s:22:\"portal_news_showavatar\";s:1:\"0\";s:20:\"portal_news_showicon\";s:1:\"1\";s:22:\"portal_news_showrating\";s:1:\"0\";s:25:\"portal_news_showsignature\";s:1:\"0\";}}',
    	`modules` = '34,2,1,29,38,9,7,19,35,37,6,45,4,13,25,36',
    	`userperms` = '1,2,3,4,5,6,7,8'
    WHERE pageid = 1;
    
    MySQL Error  : Out of range value adjusted for column 'styleid' at row 1
    Error Number : 1264
    I had a similar problem with editing my basic style in VB. I asked for help on the VB site and the solution was this:

    Code:
    ALTER TABLE style CHANGE templatelist templatelist MEDIUMTEXT;
    So now I am looking for help with my CMPS error which I believe may be related. On the VB site I was informed that one of my mods/hacks may have altered the table structure.

    Can anyone help me resolve this?

    Thank you in advance.

  2. #2
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Moved site to new server, problems with CMPS edit page

    That column should already be able to handle the text you've posted. If you run this query though it *should* take care of the problem.

    Code:
    ALTER TABLE `adv_pages` CHANGE `advanced` `advanced` TEXT NOT NULL

  3. #3
    Join Date
    Apr 2005
    Posts
    290

    Default Re: Moved site to new server, problems with CMPS edit page

    I ran that query (5 rows affected) and I am still receiving this error:

    MySQL Error : Out of range value adjusted for column 'styleid' at row 1
    Error Number : 1264

  4. #4
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Moved site to new server, problems with CMPS edit page

    Sorry about that, I think I read over the error too quickly the first time. It looks like MySQL may have changed the way they handle negative integers being inserted into unsigned columns in v5.0. If you'll look in your vba_cmps_admin.php file for this code:
    PHP Code:
        $db->query_write(fetch_query_sql($page'adv_pages'iif($_POST['do'] == 'doeditpage''WHERE pageid = ' $pageid))); 
    And add this right above:
    PHP Code:
        if ($page['styleid'] == '-1')
        {
            
    $page['styleid'] = 0;
        } 
    That should take care of the problem.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Moved site to new server, can't figure out how to get vba up
    By 8kobe in forum Troubleshooting & Problems
    Replies: 5
    Last Post: 07-10-2006, 02:12 PM
  2. On my cmps first page I have a Site Navagation Box
    By Garrylawton in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 07-08-2006, 12:08 AM
  3. CMPS News Page Issue - Server Change
    By Earl Grey in forum Troubleshooting / "How do I..." Questions
    Replies: 4
    Last Post: 02-18-2005, 03:44 PM

Posting Permissions

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