Installation, Configuration, & Upgrades  :: 
1064
 Top

  • This issue has been discussed here before, but, I get the MySQL 1064 error when trying to dump the SQL-file in the database. When running install.php, nothing happens what so ever, a white bland screen.
  • webguide

    This issue has been discussed here before, but, I get the MySQL 1064 error when trying to dump the SQL-file in the database. When running install.php, nothing happens what so ever, a white bland screen.


    Doesnt any one know?
  • You are doing a new install of .762?

    If so, I think you will have much better luck creating an empty data base and letting the install script create the tables and DB structure.

    And details like the version MySQL and PHP can make a difference, so it is worth including that information in your posts.

    --
    Peace
    ______________________________________
    The commonest cause of problems is solutions.
  • AS I mentioned when I run the install.php script nothing happens, a blank white screen thats all.
    I have tried both PHP 4 and 5. I suppose this is the MySql-version: MySQL 4.0.24_Debian-10sarge1-log




    edited by: webguide, May 20, 2006 - 01:27 PM
  • Any one? the install.php does not work, it does nothing, white, blank, no errors, no text... The databease password, username, dbname is correct and double. and tripple checked...
  • I am far from a MySQL guru but I believe the 1064 error is because you need MySQL 4.1 or later to run sub queries.

    There have been problems with using the MySQL dump which is why the advice here is consistently that you should:
    1. Create a DB (empty)
    2. Upload the PN files
    3. After carefully reading the instructions in the doc folder...Point your browser at install.php and do the install, entering the DB info when prompted and letting install.php use its scripts to do the work.

    I am not sure at what point you get stuck.

    You point your browser at install.php and get a BLANK SCREEN? Or you can get to install.php but somewhere after that you get a BLANK SCREEN.

    Have you looked at the blank page tutorial by Mark West - blank pages are not a specific error but are a symtpoms of a potentially large variety of issues and this tutorial often helps narrow it down.

    --
    Peace
    ______________________________________
    The commonest cause of problems is solutions.
  • I get a BLANK SCREEN, does not go anywhere att all. I have created a database, I have also played around with the chmoding of the files...
  • webguide

    I get a BLANK SCREEN, does not go anywhere att all. I have created a database, I have also played around with the chmoding of the files...


    When do you get the BLANK SCREEN?


    You have:
    1. Created the database...?
    2. Uploaded the files that unpack inside the HTML directory of PN 0.762 into www.yoursite.com...?
    3. Made config.php, config-old.php, pnTemp (and subdirectories) world-writable...?
    4. Pointed your browser at www.yoursite.com/install.php...?


    And that is when you get a BLANK SCREEN?


    The BLANK SCREEN when you attempt to access a file.php generally means something wrong with the PHP code causing the script to die without generating an error message.


    First, I would simply verify that PHP works:


    Create a file called myphpinfo.php with the following code:

    Code

    <?php phpinfo(); ?>


    Upload it to your site and point your browser at it. You should get a listing of the PHP configuration on your site.


    If this works, the next thing I would do is simply re-upload the install.php file and then try it again.


    If still no joy, you need to turn on error reporting. Assuming you do not have shell access, you need to create an .htaccess file in your root (where config.php, config-old.php are) with the following in the .htaccess file:


    Code

    php_flag display_errors on



    Now try pointing at the install.php -> with any luck, you should get an error message instead of a BLANK SCREEN.


    If you STILL get a Blank Page, I think there is a line in includes/pnAPI.php you will have to change - but I do not remember which line at the moment - it is in the Blank Page tutorial I mentioned above.


    (Apologies if you already know and have tried all this - but your request for help has been scant on details beyond that you get a Blank Page.)

    HTH






    edited by: pheski, May 21, 2006 - 04:50 PM

    --
    Peace
    ______________________________________
    The commonest cause of problems is solutions.
  • Hi,

    Great this give me an internal error (500), hmmm I will check the code, wo you know of any known issues resulting in a server error?
  • Reupload your files. Or better, upload them compressed (tar or zip) and decompress them in place.

    --
    Peace
    ______________________________________
    The commonest cause of problems is solutions.
  • OK, I cant unpack the files on the server, but I did transfer the files directly from the zip to the server.
    But I still get an error 500.



    edited by: webguide, May 22, 2006 - 01:48 PM
  • It does not work...
  • I would say you have a problem with getting all your files uploaded... My server kept resetting on me when I was uploading files.. So there could be some missing...

    --
    My attempt at PN can be found @
    www.ThoughtsFrom.Us
This list is based on the users active over the last 60 minutes.