My installation is failing when it trys to populate the database tables.
SELECT t.treeid FROM sq_asset_link_tree t INNER JOIN sq_asset_link l ON t.linkid = l.linkid WHERE l.minorid = 1 LIMIT 1 LIMIT 0, 1
It seems the LIMIT clause is in the statement twice.
I'm running RHEL, Apache 2.046, MySQL 4.11, PHP 4.3.2
Full error page:
MySource Error
[ASSERT EXCEPTION] DB Error: syntax error
SELECT t.treeid FROM sq_asset_link_tree t INNER JOIN sq_asset_link l ON t.linkid = l.linkid WHERE l.minorid = 1 LIMIT 1 LIMIT 0, 1 [nativecode=1064 ** 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 'LIMIT 0, 1' at line 3] (LINE 2650 IN [SYSTEM_ROOT]/core/include/asset_manager.inc)
Install Order :
0 => "page",
1 => "design_area",
2 => "design",
3 => "design_css",
4 => "design_area_menu_type",
5 => "design_area_menu_recursive",
6 => "design_area_menu_normal",
7 => "design_area_body",
8 => "design_area_head",
9 => "design_area_nest_content",
10 => "design_area_declared_vars",
11 => "design_area_metadata",
12 => "design_area_custom_image",
13 => "design_area_datetime",
14 => "design_area_constant_button",
15 => "design_area_colourise_image",
16 => "design_area_asset_lineage",
17 => "design_area_linked_css",
18 => "design_area_login_form",
19 => "design_customisation",
20 => "metadata_field",
21 => "file",
22 => "image",
23 => "word_doc",
24 => "pdf_file",
25 => "thumbnail",
26 => "user",
27 => "inbox",
28 => "backend_user",
29 => "page_standard",
30 => "bridge",
31 => "folder",
32 => "workflow_schema",
33 => "workflow_step_condition",
34 => "workflow_step",
35 => "report",
36 => "cron_manager",
37 => "cron_job",
38 => "trash_folder",
39 => "layout_manager",
40 => "designs_folder",
41 => "root_folder",
42 => "system_management_folder",
43 => "authentication",
44 => "authentication_folder",
45 => "cache_manager",
46 => "system_user",
47 => "remap_manager",
48 => "login_design",
49 => "bodycopy_container",
50 => "bodycopy_div",
51 => "bodycopy_table",
52 => "bodycopy",
53 => "content_type",
54 => "site",
55 => "design_css_customisation",
56 => "design_area_menu_stalks",
57 => "metadata_field_select",
58 => "metadata_field_date",
59 => "metadata_field_text",
60 => "metadata_schema",
61 => "metadata_section",
62 => "report_incomplete_metadata",
63 => "workspace",
64 => "user_group",
65 => "content_type_wysiwyg",
66 => "layout",
67 => "cron_job_future_status",
68 => "cron_job_future_lineage",
69 => "system_user_group",
70 => "root_user",
71 => "authentication_default"
Root Folder Asset Id : 1