×

Discussion Board

Results 1 to 4 of 4
  1. #1
    Registered User
    Join Date
    Apr 2008
    Posts
    1

    Error on index creation - MySQL + PAMP

    I'm running the latest PAMP on my N95-4 8GB, and everything seems to be running just fine. Except:

    First I create a table:

    Code:
    CREATE table `civicaddress` (
    `street_no` int(11) NULL,
    `street_nm` char(50) NULL,
    `comm_nm` char(30) NULL,
    `apt_no` char(10) NULL,
    `county` char(3) NULL,
    `latitude` real(11,5) NULL,
    `longitude` real(11,5) NULL);
    This works without any problems.

    Next, I attempt to create an index, and get the following error:

    Code:
    mysql> CREATE index `StreetNumberDex` on civicaddress  (street_no);
    ERROR 7 (HY000): Error on rename of \
    '.\civicaddress\civicaddress.MYI' to \
    '.\civicaddress\#sql2-198-1.MYI' (Errcode: 2)
    I can successfully create the index by dropping the table and creating the index at table creation time, but I don't seem to be able to create any indices after the fact.

  2. #2
    Nokia Developer Expert
    Join Date
    Mar 2003
    Posts
    457

    Re: Error on index creation - MySQL + PAMP

    Hi,

    Quote Originally Posted by ruk View Post
    I can successfully create the index by dropping the table and creating the index at table creation time, but I don't seem to be able to create any indices after the fact.
    I could repeat the problem and will look into it.

    Johan

  3. #3
    Nokia Developer Expert
    Join Date
    Mar 2003
    Posts
    457

    Re: Error on index creation - MySQL + PAMP

    Quote Originally Posted by jhnwkmn View Post
    Quote Originally Posted by ruk View Post
    I can successfully create the index by dropping the table and creating the index at table creation time, but I don't seem to be able to create any indices after the fact.
    I could repeat the problem and will look into it.
    It seems to be so that at the index creation when MySQL renames the file civicaddress.MYI, MySQL has that file opened as well. On Unix it is fine to rename a file that is also opened, but on Symbian you cannot do that. Thus the renaming fails and therefore also the index creation. For the time being, you just have to create the index at table creation time.

    Johan

  4. #4
    Nokia Developer Expert
    Join Date
    Mar 2003
    Posts
    457

    Re: Error on index creation - MySQL + PAMP

    Quote Originally Posted by ruk View Post
    I can successfully create the index by dropping the table and creating the index at table creation time, but I don't seem to be able to create any indices after the fact.
    I've now uploaded to SourceForge a version that allows you to create indexes after the fact. You need to first install the full 1.0.2 Pamp MySQL package, then uninstall the MySQL-5_0_67 Binaries package on the phone, and finally install the sis-file in the 1.0.2b zip.

    Johan

Similar Threads

  1. MySQL on pamp
    By stevenmartin99 in forum Mobile Web Server
    Replies: 0
    Last Post: 2008-02-03, 19:52
  2. ScrollPane, PP on Nokia 9500 Emu
    By pkc2k in forum Personal Profile
    Replies: 1
    Last Post: 2005-12-06, 16:58
  3. HTTP POST failing and discrepancy of string tables in SDK and 6600
    By cas_dominic in forum Symbian Networking & Messaging (Closed)
    Replies: 0
    Last Post: 2004-05-31, 08:08
  4. Any algorithm of wav compression
    By kingsimba in forum Symbian
    Replies: 3
    Last Post: 2004-01-03, 09:00

Posting Permissions

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