Error SQLite !!!

[Wifixs]

------------------------------------------------------------------------

OTSYS_SQLITE_PREPARE<>:SQLITE ERROR: no such table : z_ots_comunication * FROM z_ots_comunication WHERE "type" = 'login' ;>

------------------------------------------------------------------------

 

[_Arthur]

Execute this query in PMA.

CREATE TABLE `z_ots_comunication` (
`id` int(11) NOT NULL auto_increment, PRIMARY
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`param1` varchar(255) NOT NULL,
`param2` varchar(255) NOT NULL,
`param3` varchar(255) NOT NULL,
`param4` varchar(255) NOT NULL,
`param5` varchar(255) NOT NULL,
`param6` varchar(255) NOT NULL,
`param7` varchar(255) NOT NULL,
`delete_it` int(2) NOT NULL default '1',
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

[Wifixs]

ok thanks but this direction where is ... data / mods / schemas / doc ??????

 

[_Arthur]

PHPMYADMIN = localhost? <,<

 

[Dominik ms]

Sqlite in localhost??

 

[Wifixs]

Near "auto_increment": syntax error.

EurekaLog 6.0.24

Application:
--------------------------------------------------------------------------------------------
  1.1 Start Date      : Fri, 22 Oct 2010 16:58:40 +0200
  1.2 Name/Description: SQLiteExpertPers.exe - (The complete administration tool for SQLite)
  1.3 Version Number  : 3.1.23.2099
  1.4 Parameters      : 
  1.5 Compilation Date: Tue, 19 Oct 2010 01:28:01 +0200
  1.6 Up Time         : 16 minutes, 39 seconds

Exception:
------------------------------------------------------------------------------------------
  2.1 Date          : Fri, 22 Oct 2010 17:15:19 +0200
  2.2 Address       : 009C8437
  2.3 Module Name   : SQLiteExpertPers.exe - (The complete administration tool for SQLite)
  2.4 Module Version: 3.1.23.2099
  2.5 Type          : ESQLiteException
  2.6 Message       : near "auto_increment": syntax error.
  2.7 ID            : 5BBC
  2.8 Count         : 1
  2.9 Status        : New
  2.10 Note         : 

User:
-------------------------------------------------------
  3.1 ID        : Cesar
  3.2 Name      : Cesar
  3.3 Email     : 
  3.4 Company   : 
  3.5 Privileges: SeChangeNotifyPrivilege         - ON
                  SeSecurityPrivilege             - OFF
                  SeBackupPrivilege               - OFF
                  SeRestorePrivilege              - OFF
                  SeSystemtimePrivilege           - OFF
                  SeShutdownPrivilege             - OFF
                  SeRemoteShutdownPrivilege       - OFF
                  SeTakeOwnershipPrivilege        - OFF
                  SeDebugPrivilege                - OFF
                  SeSystemEnvironmentPrivilege    - OFF
                  SeSystemProfilePrivilege        - OFF
                  SeProfileSingleProcessPrivilege - OFF
                  SeIncreaseBasePriorityPrivilege - OFF
                  SeLoadDriverPrivilege           - ON
                  SeCreatePagefilePrivilege       - OFF
                  SeIncreaseQuotaPrivilege        - OFF
                  SeUndockPrivilege               - ON
                  SeManageVolumePrivilege         - OFF
                  SeImpersonatePrivilege          - ON
                  SeCreateGlobalPrivilege         - ON

Active Controls:
-------------------------------------------------------
  4.1 Form Class   : TfrmSCMain
  4.2 Form Text    : SQLite Expert Personal 3.1.23.2099
  4.3 Control Class: TfrmSCMain
  4.4 Control Text : 

Computer:
--------------------------------------------------------------------------------------
  5.1 Name          : CESAR-2B9F1E5DA
  5.2 Total Memory  : 1012 Mb
  5.3 Free Memory   : 397 Mb
  5.4 Total Disk    : 12.33 Gb
  5.5 Free Disk     : 5.12 Gb
  5.6 System Up Time: 12 hours, 43 minutes, 18 seconds
  5.7 Processor     : Intel(R) Atom(TM) CPU N270   @ 1.60GHz
  5.8 Display Mode  : 800 x 600, 32 bit
  5.9 Display DPI   : 96
  5.10 Video Card   : Mobile Intel(R) 945 Express Chipset Family (driver 6.14.10.4926)
  5.11 Printer      : Microsoft XPS Document Writer (driver 6.0.6001.22204)

Operating System:
------------------------------------
  6.1 Type    : Microsoft Windows XP
  6.2 Build # : 2600
  6.3 Update  : Service Pack 3
  6.4 Language: Spanish
  6.5 Charset : 0

Network:
---------------------------------------------------
  7.1 IP Address: 000.000.000.000 - 192.168.001.129
  7.2 Submask   : 000.000.000.000 - 255.255.255.000
  7.3 Gateway   : 000.000.000.000 - 192.168.001.254
  7.4 DNS 1     : 000.000.000.000 - 192.168.001.254
  7.5 DNS 2     : 000.000.000.000 - 000.000.000.000
  7.6 DHCP      : ON              - ON