installation problem in step 3

mathus · December 30, 2012

facing installation problems in step 3, any idea how to solve it? Thanks in adv. Mathus

Attached the error messages:

=========== START =========

3. Test Database and Save Configuration

Database connection successful to tailiswa_tailiswa

Saved database configuration to ./site/config.php

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\', PRIMARY KEY (`pages_id`), KEY `data_exact` (`data`), FULLTEXT KEY `' at line 2

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\',\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\', `data` int(11) NOT NULL default \'0\', PRIMARY KEY (`pages_id`), K' at line 1

Table 'tailiswa_tailiswa.field_process' doesn't exist

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Edit Template\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Add Template\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Templates\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Field groups\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Edit Fieldgroup\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Fields\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Edit Field\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Setup\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Pages\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Add Page\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Page List\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Save Sort\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Edit Page\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Modules\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Users\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Roles\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Admin\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Trash\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'404 Page Not Found\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Insert Link\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Login\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Profile\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Empty Trash\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Search\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Insert Image\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Access\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Permissions\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Edit pages\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Delete pages\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Move pages (change parent)\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'View pages\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Sort child pages\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Change templates on pages\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Administer users (role must also have template edit access)\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'User can update profile/password\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Lock or unlock a page\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\', `flags` int(11) NOT NULL default \'0\', `cache_time` mediumint(9) NOT' at line 3

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'admin\',2,8,0,\'{\\\"useRoles\\\":1,\\\"parentTemplates\\\":[2],\\\"allowPageN' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'user\',3,8,0,\'{\\\"useRoles\\\":1,\\\"noChildren\\\":1,\\\"parentTemplates\\\' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'role\',4,8,0,\'{\\\"noChildren\\\":1,\\\"parentTemplates\\\":[2],\\\"slashUrls' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'permission\',5,8,0,\'{\\\"noChildren\\\":1,\\\"parentTemplates\\\":[2],\\\"sla' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'admin\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'user\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'role\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'permission\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\', `fields_id` int(10) unsigned NOT NULL default \'0\', `sort` int(11) u' at line 1

Table 'tailiswa_tailiswa.fieldgroups_fields' doesn't exist

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\', `label` varchar(255) NOT NULL default \'\', `data` text NOT NULL, P' at line 4

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypePageTitle\',\'title\',13,\'Title\',\'{\\\"required\\\":1,\\\"textform' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeModule\',\'process\',25,\'Process\',\'{\\\"description\\\":\\\"The pr' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypePassword\',\'pass\',24,\'Set Password\',\'{\\\"collapsed\\\":1,\\\"si' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypePage\',\'permissions\',24,\'Permissions\',\'{\\\"derefAsPage\\\":0,\\' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypePage\',\'roles\',24,\'Roles\',\'{\\\"derefAsPage\\\":0,\\\"parent_id\' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeEmail\',\'email\',9,\'E-Mail Address\',\'{\\\"size\\\":70,\\\"maxleng' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\', `data` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `class` (`cla' at line 3

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeTextarea\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeNumber\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeText\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypePage\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldForm\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeFile\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageEdit\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessLogin\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'TextformatterPstripper\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageList\',0,\'{\\\"pageLabelField\\\":\\\"title\\\",\\\"paginationLimi' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageEditLink\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageSort\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldPageListSelect\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'JqueryUI\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageAdd\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'SessionLoginThrottle\',3,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldPassword\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldAsmSelect\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'JqueryCore\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeModule\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeDatetime\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeEmail\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldURL\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldSubmit\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldWrapper\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldText\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldTextarea\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldSelect\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldCheckbox\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldCheckboxes\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldRadios\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldHidden\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldName\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldSelectMultiple\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'JqueryWireTabs\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPage\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessTemplate\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessField\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessModule\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'PagePermissions\',3,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeCheckbox\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'PageRender\',3,\'{\\\"clearCache\\\":1}\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldFile\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldImage\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeImage\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldPage\',0,\'{\\\"inputfieldClasses\\\":[\\\"InputfieldSelect\\\",\\\"' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'TextformatterEntities\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'TextformatterMarkdownExtra\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'TextformatterSmartypants\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessUser\',0,\'{\\\"showFields\\\":[\\\"name\\\",\\\"email\\\",\\\"roles\\\' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'MarkupAdminDataTable\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessRole\',0,\'{\\\"showFields\\\":[\\\"name\\\"]}\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessList\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldFieldset\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldMarkup\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldEmail\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeFloat\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageView\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeInteger\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldInteger\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldPageName\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessHome\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldFloat\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldTinyMCE\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldDatetime\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'MarkupPagerNav\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageEditImageSelect\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'JqueryFancybox\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'JqueryTableSorter\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageSearch\',1,\'{\\\"searchFields\\\":\\\"title body\\\",\\\"displayFi' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeFieldsetOpen\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeFieldsetClose\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeFieldsetTabOpen\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageTrash\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypePageTitle\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldPageTitle\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'MarkupPageArray\',3,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldButton\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypePassword\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPageType\',1,\'{\\\"showFields\\\":[]}\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeURL\',1,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessPermission\',1,\'{\\\"showFields\\\":[\\\"name\\\",\\\"title\\\"]}\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'InputfieldPageListSelectMultiple\',0,\'\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessProfile\',1,\'{\\\"profileFields\\\":[\\\"pass\\\",\\\"email\\\"]}\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'SystemUpdater\', 1, \'{\"systemVersion\":1}\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\', `templates_id` int(11) unsigned NOT NULL default \'0\', `name` varcha' at line 2

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'home\',9,\'2011-09-06 14:50:01\',41,\'0000-00-00 00:00:00\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'processwire\',1035,\'2011-08-14 22:04:52\',41,\'0000-00-00 00:00:00\',2,5)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'page\',21,\'2011-03-29 21:37:06\',41,\'0000-00-00 00:00:00\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'add\',21,\'2011-03-29 21:37:06\',41,\'0000-00-00 00:00:00\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'trash\',1039,\'2011-08-14 22:04:52\',41,\'2010-02-07 05:29:39\',2,6)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'list\',21,\'2011-03-29 21:37:06\',41,\'0000-00-00 00:00:00\',2,1)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'sort\',23,\'2011-03-29 21:37:06\',41,\'0000-00-00 00:00:00\',2,2)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'edit\',21,\'2011-03-29 21:37:06\',41,\'0000-00-00 00:00:00\',2,3)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'template\',21,\'2011-03-29 21:37:06\',41,\'2010-02-01 11:04:54\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'field\',21,\'2011-03-29 21:37:06\',41,\'2010-02-01 12:44:07\',2,2)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'module\',21,\'2011-03-29 21:37:06\',41,\'2010-02-02 10:02:24\',2,2)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'setup\',21,\'2011-03-29 21:37:06\',41,\'2010-02-09 12:16:59\',2,1)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'login\',1035,\'2011-05-03 23:38:10\',41,\'2010-02-17 09:59:39\',2,4)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'http404\',1035,\'2011-08-14 22:04:52\',41,\'2010-06-03 06:53:03\',3,4)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'access\',13,\'2011-05-03 23:38:10\',41,\'2011-03-19 19:14:20\',2,3)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'users\',29,\'2011-04-05 00:39:08\',41,\'2011-03-19 19:15:29\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'roles\',29,\'2011-04-05 00:38:39\',41,\'2011-03-19 19:15:45\',2,1)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'permissions\',29,\'2011-04-05 00:53:52\',41,\'2011-03-19 19:16:00\',2,2)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'page-edit\',25,\'2011-09-06 15:34:24\',41,\'2011-03-19 19:17:03\',2,2)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'page-delete\',25,\'2011-09-06 15:34:33\',41,\'2011-03-19 19:17:23\',2,3)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'page-move\',25,\'2011-09-06 15:34:48\',41,\'2011-03-19 19:17:41\',2,4)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'page-view\',25,\'2011-09-06 15:34:14\',41,\'2011-03-19 19:17:57\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'guest\',25,\'2011-04-05 01:37:19\',41,\'2011-03-19 19:18:41\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'superuser\',25,\'2011-08-17 14:34:39\',41,\'2011-03-19 19:18:55\',2,1)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'admin\',1,\'2011-08-15 15:01:46\',41,\'2011-03-19 19:41:26\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'guest\',25,\'2011-08-17 14:26:09\',41,\'2011-03-20 17:31:59\',2,1)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'page-sort\',25,\'2011-09-06 15:34:58\',41,\'2011-03-26 22:04:50\',41,5)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'page-template\',25,\'2011-09-06 15:35:09\',41,\'2011-03-26 22:25:31\',41,6)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'user-admin\',25,\'2011-09-06 15:35:42\',41,\'2011-03-30 00:06:47\',41,10)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'profile-edit\',1,\'2011-08-16 22:32:48\',41,\'2011-04-26 00:02:22\',41,13)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'page-lock\',1,\'2011-08-15 17:48:12\',41,\'2011-08-15 17:45:48\',41,8)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'search\',21,\'2011-03-29 21:37:06\',41,\'2010-08-04 05:23:59\',2,5)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'trash\',23,\'2011-03-29 21:37:06\',41,\'2010-09-28 05:39:30\',2,5)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'link\',17,\'2011-03-29 21:37:06\',41,\'2010-10-01 05:03:56\',2,6)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'image\',17,\'2011-03-29 21:37:06\',41,\'2010-10-13 03:56:48\',2,7)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'profile\',1025,\'2011-05-03 23:38:10\',41,\'2011-04-25 23:57:18\',41,5)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'2011-09-06 12:10:09\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\', `sortfield` varchar(20) NOT NULL default \'\', PRIMARY KEY (`pages_i' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\', `last_attempt` int(10) unsigned NOT NULL, PRIMARY KEY (`name`) ) ENG' at line 2

Imported: ./wire/core/install.sql

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'

The page you were looking for is not found.

\\r\\n

Please use our se' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'

What is ProcessWire?

ProcessWire gives you full control over your f' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'

Ut capio feugiat saepius torqueo olim

In utinam facilisi eum vicis' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'

The site template files are located in /site/templates/

Each of the' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'

Si lobortis singularis genitus ibidem saluto.

Dolore ad nunc, mos a' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'

Pertineo vel dignissim, natu letalis fere odio

Si lobortis singula' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Basic Example Site\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'About Us\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Developing Site Templates\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'westin_interior2.jpg\',7,\'Westin Peachtree Atlanta hotel lobby area.\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'marquis_interior7b.jpg\',5,\'Elevator at the Atlanta Marriott Marquis hotel.\'' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'marquis_interior13b_med.jpg\',6,\'Atrium at the Atlanta Marriott Marquis hotel' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'marquis_interior3.jpg\',4,\'Elevator core at the Atlanta Marriott Marquis hote' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'hyatt_interior11.jpg\',3,\'Looking up from the lobby area at the Atlanta Hyatt' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'hyatt2.jpg\',2,\'Detail from Atlanta Hyatt Hotel.\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'hyatt_interior9.jpg\',1,\'Detail from Atlanta Hyatt Hotel.\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'westin_interior1.jpg\',0,\'Westin Peachtree Atlanta hotel lobby area.\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'

About ProcessWire

ProcessWire is an open source CMS and web applica' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'

Sudo nullus

Et torqueo vulpes vereor luctus augue quod consectetuer' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Dolore ea valde refero feugait utinam luctus. Probo velit commoveo et, delenit' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'This is a placeholder page with two child pages to serve as an example. \')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'View this template\\\'s source for a demonstration of how to create a basic si' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'More about the templates included in this basic site profile. \')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Mos erat reprobo in praesent, mara premo, obruo iustum pecus velit lobortis te' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'ProcessWire is an open source CMS and web application framework aimed at the n' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Home\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'About\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Child page example 1\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Search\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Templates\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Child page example 2\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Site Map\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'home\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'sitemap\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'basic-page\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'search\')' at line 1

Table 'tailiswa_tailiswa.fieldgroups_fields' doesn't exist

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeTextarea\',\'sidebar\',0,\'Sidebar\',\'{\\\"inputfieldClass\\\":\\\"I' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeImage\',\'images\',0,\'Images\',\'{\\\"extensions\\\":\\\"gif jpg jpe' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeTextarea\',\'summary\',1,\'Summary\',\'{\\\"textformatters\\\":[\\\"T' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeTextarea\',\'body\',0,\'Body\',\'{\\\"inputfieldClass\\\":\\\"Inputfi' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'FieldtypeText\',\'headline\',0,\'Headline\',\'{\\\"description\\\":\\\"Use thi' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'search\',1025,\'2011-08-31 19:17:38\',41,\'2010-09-06 05:05:28\',2,3)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'about\',1,\'2011-09-05 16:02:24\',41,\'2010-10-25 22:39:33\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'what\',1,\'2011-09-06 14:50:53\',41,\'2010-10-25 23:21:34\',2,0)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'templates\',1,\'2011-09-05 16:08:59\',41,\'2010-10-26 01:59:44\',2,1)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'background\',1,\'2011-08-18 14:47:47\',41,\'2010-11-29 22:11:36\',2,1)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'site-map\',1,\'2011-08-31 19:17:38\',41,\'2010-11-30 21:16:49\',2,2)' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'home\',1,0,0,\'{\\\"useRoles\\\":1,\\\"noParents\\\":1,\\\"slashUrls\\\":1,\\\' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'basic-page\',83,0,0,\'{\\\"slashUrls\\\":1}\')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'search\',80,0,0,\'{\\\"noChildren\\\":1,\\\"noParents\\\":1,\\\"allowPageNum\\' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'sitemap\',88,0,0,\'{\\\"noChildren\\\":1,\\\"noParents\\\":1,\\\"redirectLogin' at line 1

Table 'tailiswa_tailiswa.pages' doesn't exist

Imported: ./site/install/install.sql

Created directory: ./site/assets/cache/

Created directory: ./site/assets/logs/

Created directory: ./site/assets/sessions/

Imported: ./site/install/files => ./site/assets/files/

========END==========

pw-installation_errors.rtf

Pete · December 30, 2012

Ooh, that looks nasty. Can you let us know your PHP and mySQL versions please?

ryan · December 31, 2012

Sounds like something is not quite right with the MySQL you are running, whether it's version related or something missing from MySQL (fulltext index support?). I think the first error reveals everything that we need to know:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\', PRIMARY KEY (`pages_id`), KEY `data_exact` (`data`), FULLTEXT KEY `' at line 2

If that is failing, then something isn't right with the MySQL server. Let us know what version, or you can PM me a link to a phpinfo file. If this is occurring at some specific webhost (rather than your own computer), let us know of that too.

mathus · January 5, 2013

Please find my phpinfo content in the attachment and below is the version of mysql server retrived from (SHOW VARIABLES LIKE "%version%")

Host: localhost

Database:

Generation Time: Jan 05, 2013 at 03:54 PM

Generated by: phpMyAdmin 3.5.3 / MySQL 5.5.28-cll

SQL query: SHOW VARIABLES LIKE "%version%";

Rows: 7

Variable_name Value

innodb_version 1.1.8

protocol_version 10

slave_type_conversions

version 5.5.28-cll

version_comment MySQL Community Server (GPL)

version_compile_machine x86_64

version_compile_os Linux

I host the site in the webhost company in asia, and also gusess the error may caused by the MySQL server but I am not clever enough to resolve the problem.

Thanks Pete and ryan respones anyway and I will keep looking for the solution in the mean time.

P.S.: re-post the file again php_info1.php.htm

ryan · January 5, 2013

Your versions and PHPinfo seem to look fine to me. The errors that you got make me think the most likely scenario is that somehow your install.sql got corrupted, had it's character set changed, or got modified before installation in some manner. Have you tried a fresh install? If you still get the same error, try posting your /site/install/install.sql and /wire/core/install.sql.

mathus · January 6, 2013

Attached both install.sql files. backup.zip

By the way, I ran all the sql statements in both install.sql files directly to the mysql database via phpmyadmin. It did create all the tables for me. Then I ignore the error msgs in step 3 and input the superuser account and click continue. Another fatal error comes up .

I think go through the step 3 of the installation sucessfully before process to next step is a must, am I right

I did try a few fresh setup before, no luck to me.

Thanks in advance.

Mathus

ryan · January 6, 2013

One possible issue here is that your install files have Windows line breaks (CR+LF), whereas ProcessWire's files are supposed to have unix line breaks. So it looks like the files must have gone through some save or filter at some point. Though if I omit whitespace from the diff, it finds no differences. Since the error seems fairly mysterious at this point, I think it would be worth checking if maybe your FTP client used an ASCII upload (rather than binary) when pushing these files to your server. It's possible that the file format changed as a result of that. I will keep trying to think if there is anything else we can try. If you want to PM me account credentials (FTP or SSH) I'm also happy to login and debug it that way too.

mathus · January 7, 2013

ryan, you are right, the installation has been completed successfully after I upload processwire using another ftp client.

Filezilla is used for upload processwire before with problem for some reason that i will firgure it out what i did wrong. Now my processwire site is work and running.

Many thanks.

Sign In

installation problem in step 3

Recommended Posts

mathus

Link to comment

Share on other sites

Pete

Link to comment

Share on other sites

ryan

Link to comment

Share on other sites

mathus

Link to comment

Share on other sites

ryan

Link to comment

Share on other sites

mathus

Link to comment

Share on other sites

ryan

Link to comment

Share on other sites

mathus

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Browse

Activity

My Activity Streams

Store

My Details

Support