Log in | Register | Lost password

Bottom
Adding a album gives error - Installer settings wrong ?
  • Posted: 22.03.2006, 08:42
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    I installed a fresh copy of photoshare. The installer gave me a few errors i could resolve. Mainly because of the alter table action during install and having not enough rights for this. I tuned my mysql tide on this. giving the user temporary the rights to alter fixed this.

    So now everything seems to work exept adding a album at this time.
    The first error i got was that there wasn't a default value for ps_accesslevel in the photoshare folder table. A added a default value for this with myphpadmin.

    Now i get the next error messae:

    Code

    \pnuserapi.php(351): "Create folder" failed: Incorrect integer value: '' for column 'ps_hidepnframe' at row 1 while executing:



    INSERT INTO rwcms_photoshare_folders ( rwcms_photoshare_folders.ps_owner, rwcms_photoshare_folders.ps_title, rwcms_photoshare_folders.ps_description,

    rwcms_photoshare_folders.ps_topic, rwcms_photoshare_folders.ps_template, rwcms_photoshare_folders.ps_hidepnframe,

    rwcms_photoshare_folders.ps_blockfromlist, rwcms_photoshare_folders.ps_parentfolder, rwcms_photoshare_folders.ps_createddate,

    rwcms_photoshare_folders.ps_viewkey)

    VALUES ( '3', 'Water fotos', '', '-1', 'book', '', '', '-1', NOW(), round(rand()*9000000000000 + 1000000000000))


    it looks like there is no value for ps.hidepnframe while mysql has a default value of 0 for this.

    i'm using php 442 and mysql 5. Innodb table set.

    This code works in phpmyadmin (added 0 values):

    Code

    INSERT INTO rwcms_photoshare_folders ( rwcms_photoshare_folders.ps_owner, rwcms_photoshare_folders.ps_title,

    rwcms_photoshare_folders.ps_description, rwcms_photoshare_folders.ps_topic, rwcms_photoshare_folders.ps_template,

    rwcms_photoshare_folders.ps_hidepnframe, rwcms_photoshare_folders.ps_blockfromlist, rwcms_photoshare_folders.ps_parentfolder,

    rwcms_photoshare_folders.ps_createddate, rwcms_photoshare_folders.ps_viewkey)

    VALUES ( '3', 'Water fotos', '', '-1', 'book', '0', '0', '-1', NOW(), round(rand()*9000000000000 + 1000000000000))


    When adding this i also added a 0 value for blockfromlist that doesn't have a default value in mysql. Adding a 0 value for hidepnframe wasn't enough and gave me the same error. This i find strange couse the error is about hidepnframe. This has a default value and shoudn't be a problem and surly not when i add a specifiek 0 value for it. So the error could be in blockfromlist



    edited by: Quinie, Mar 22, 2006 - 09:52 AM
    Top
  • Posted: 12.06.2006, 13:12
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    http://drupal.org/node/43316

    It's about mysql strict mode. Error seems to be in querie but can be resloved by using your mysql server 5 in a 4 mode.

    Could you please look into the queries. Because running as 4 mode is no option for me.
    Top

Template courtesy of Designs By Darren.