Installing Joomla-V1.5 ja_portfolio quickstart fails.

Forums    Joomla Templates Club    JA Portfolio    Installing Joomla-V1.5 ja_portfolio quickstart fails.
Viewing 15 posts - 1 through 15 (of 22 total)
1 2
  • Author
    Posts
  • carlucci Friend
    January 22, 2012 at 6:41 pm #173068

    Installing Joomla-V1.5 ja_portfolio quickstart fails.
    I downloaded 2 times the file.

    Error:
    —————————————————————————
    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 ‘TYPE=MyISAM AUTO_INCREMENT=9’ at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL AUTO_INCREMENT, `cid` int(11) NOT NULL DEFAULT ‘0’, `type` varchar(30) NOT NULL DEFAULT ‘banner’, `name` varchar(255) NOT NULL DEFAULT ”, `alias` varchar(255) NOT NULL DEFAULT ”, `imptotal` int(11) NOT NULL DEFAULT ‘0’, `impmade` int(11) NOT NULL DEFAULT ‘0’, `clicks` int(11) NOT NULL DEFAULT ‘0’, `imageurl` varchar(100) NOT NULL DEFAULT ”, `clickurl` varchar(200) NOT NULL DEFAULT ”, `date` datetime DEFAULT NULL, `showBanner` tinyint(1) NOT NULL DEFAULT ‘0’, `checked_out` tinyint(1) NOT NULL DEFAULT ‘0’, `checked_out_time` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `editor` varchar(50) DEFAULT NULL, `custombannercode` text, `catid` int(10) unsigned NOT NULL DEFAULT ‘0’, `description` text NOT NULL, `sticky` tinyint(1) unsigned NOT NULL DEFAULT ‘0’, `ordering` int(11) NOT NULL DEFAULT ‘0’, `publish_up` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `publish_down` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `tags` text NOT NULL, `params` text NOT NULL, PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), KEY `idx_banner_catid` (`catid`) ) TYPE=MyISAM AUTO_INCREMENT=9

    ————————————————————————–

    Instalation Joomla-V1.7 ja_portfolio quickstart works.

    pixelzombie Friend
    January 29, 2012 at 12:22 am #435966

    Hi there,

    open installationsqlmysqlsample_data.sql in your favorite editor

    Then find and replace every instance of

    TYPE=MyISAM
    with

    ENGINE=MyISAM

    After that, the sample data can be installed.

    Cheers

    Frank

    carlucci Friend
    January 30, 2012 at 7:01 am #436122

    <em>@pixelzombie 297471 wrote:</em><blockquote>Hi there,

    open installationsqlmysqlsample_data.sql in your favorite editor

    Then find and replace every instance of

    TYPE=MyISAM

    with

    ENGINE=MyISAM

    After that, the sample data can be installed.

    Cheers

    Frank</blockquote>

    Ich habe den Eindruck, dass ich nicht gut erklärt habe.
    Sie müssen Ihre ursprüngliche Datei überprüfen.
    Sobald es geändert wird, dann kann ich es noch einmal herunterladen.
    In der ursprünglichen Datei, fehlt der ganze Anfang.
    Das heißt, die Datei ist truncated. Die Datei beginnt so :

    ¨TRUNCATE TABLE `#__banner`;

    —
    — Dumping data for table `j2d884_banner`
    —

    INSERT INTO `#__banner` (`bid`, `cid`, `type`, `name`, `alias`, `imptotal`, `impmade`, `clicks`,

    Und muss so anfangen :

    DROP TABLE IF EXISTS `#__assets`;
    CREATE TABLE `#__assets` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘Primary Key’,
    `parent_id` int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘Nested set parent.’,
    `lft` int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘Nested set lft.’,
    `rgt` int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘Nested set rgt.’,
    `level` int(10) unsigned NOT NULL COMMENT ‘The cached level in the nested tree.’,
    `name` varchar(50) NOT NULL COMMENT ‘The unique name for the asset.n’,
    `title` varchar(100) NOT NULL COMMENT ‘The descriptive title for the asset.’,
    `rules` varchar(5120) NOT NULL COMMENT ‘JSON encoded access control.’,
    PRIMARY KEY (`id`),
    UNIQUE KEY `idx_asset_name` (`name`),
    KEY `idx_lft_rgt` (`lft`,`rgt`),
    KEY `idx_parent_id` (`parent_id`)
    ) ENGINE=MyISAM ;

    Nur Sie können die Datei ändern .

    Ich hoffe muss nicht noch einmal 8 Tage auf die Antwort warten.
    Gruessen

    pixelzombie Friend
    January 31, 2012 at 1:08 am #436250

    Hi carlucci,

    please understand that I use english for support so everybody else can understand what’s going on.

    First, there are 2 SQL files used during the installation progress. The first error message you’ve posted is joomla.sql located in installationsqlmysql

    I’ve attached a fresh one for you.

    The second snippet you’ve posted is from the “quickinstall” sample_data.sql and looks pretty normal. In other templates it looks the same. The only exeption I’m aware of is Mesolite II.

    Please post some details about your system you’re using for the quickinstall. Local or Live, PHP Version, MySQL Version. It could be a permission issue.

    Cheers

    Frank

    1. joomla.sql_.zip

    1 user says Thank You to pixelzombie for this useful post

    1. carlucci
    alex_feng Friend
    January 31, 2012 at 1:24 am #436254

    I had problem with wamp server 2.2 (64 bits). With wamp server 1.0 (64 bits), it works.

    1 user says Thank You to alex_feng for this useful post

    1. pixelzombie
    pixelzombie Friend
    January 31, 2012 at 1:32 am #436256

    Thank you Alex for this suggestion. That would be the next question I asked 😀 What local server version are you using?

    alex_feng Friend
    January 31, 2012 at 1:44 am #436258

    I got rid of wamp 2.2a. Now I have wamp64 installed in my local machine.

    http://forum.wampserver.com/read.php?2,66329

    1 user says Thank You to alex_feng for this useful post

    1. carlucci
    carlucci Friend
    January 31, 2012 at 12:38 pm #436334

    <em>@pixelzombie 297850 wrote:</em><blockquote>Hi carlucci,

    please understand that I use english for support so everybody else can understand what’s going on.

    First, there are 2 SQL files used during the installation progress. The first error message you’ve posted is joomla.sql located in installationsqlmysql

    I’ve attached a fresh one for you.

    The second snippet you’ve posted is from the “quickinstall” sample_data.sql and looks pretty normal. In other templates it looks the same. The only exeption I’m aware of is Mesolite II.

    Please post some details about your system you’re using for the quickinstall. Local or Live, PHP Version, MySQL Version. It could be a permission issue.

    Cheers

    Frank</blockquote>
    Sorry!
    Installation does not work.
    The problem is not in my installation.
    You (Joomlart) have to check your installation, why should not everyone who wants to get down Ja Portfolio J-1.5 have the same problem.
    The Ja Portofolio J-1.7 installation works.
    Please do not find the problem in my installation. I have installed previous version of Ja Portfolio J.1.5 and works .
    So I can not do anything to purpose.
    By changing joomla.sql with the new file, now the problem is reflected differently.

    See the ruling:
    Do not install the sample data!

    1. portfolio
    alex_feng Friend
    January 31, 2012 at 7:12 pm #436369

    Hi carlucci ,
    I had a similar installation problem with wamp server 2.2a. I failed to install any quickstarts but I could successfully install Joomla 1.5.25 full package… So there must be something wrong…….. anyway, instead of waiting someone to fix the problem for me, I got rid of wamp server 2.2a and installed its previous version and it works.
    I just installed portfolio 1.5 quickstar on my computer and it went through….. Anyway, I am just like you paying to get templates. Wamp derver 2.2 does not work on those quickstarts but wamp64 (version 1.0) works on my Window 7, 64-bit machine. Good luck!!

    1 user says Thank You to alex_feng for this useful post

    1. pixelzombie
    pixelzombie Friend
    January 31, 2012 at 11:33 pm #436405

    Hi carlucci,

    please check your local webserver type and version as Alex said. Also please reupload the screenshot. I can’t read anything 😉

    Thank you

    carlucci Friend
    March 21, 2012 at 7:32 pm #444989

    <em>@alex_feng 297859 wrote:</em><blockquote>I got rid of wamp 2.2a. Now I have wamp64 installed in my local machine.

    http://forum.wampserver.com/read.php?2,66329</blockquote>

    My system is:
    (Windows Vista Home Premium Edition Service Pack 2) i586 32-bit
    I do not think I can use wamp64.
    Or yes.?
    There are many problems with the instalación of Wamp, especially mysql.
    You can help me?

    carlucci Friend
    March 21, 2012 at 7:40 pm #444991

    <em>@pixelzombie 298050 wrote:</em><blockquote>Hi carlucci,

    please check your local webserver type and version as Alex said. Also please reupload the screenshot. I can’t read anything 😉

    Thank you</blockquote>

    I forgive you this question.
    I have other posts.
    A long time ago not help me.
    I do not understand this attitude. It should always answer in every way!!
    For this I pay, not for the templates. For me it is more important service in the forum. I am a long time with Joomlart. I’ve always had these problems. However the RocketTheme service is excellent.
    I feel I have to say these things.

    carlucci Friend
    March 21, 2012 at 8:11 pm #444995

    <em>@pixelzombie 297471 wrote:</em><blockquote>Hi there,

    open installationsqlmysqlsample_data.sql in your favorite editor

    Then find and replace every instance of

    TYPE=MyISAM

    with

    ENGINE=MyISAM

    After that, the sample data can be installed.

    Cheers

    Frank</blockquote>

    I ask a simple question!
    Why the failure happens only with Joomla 1.5 portfolio?
    All Joomlart templates are installed perfectly.
    Why exactly Portfolio?
    If Wamp failure, then it should fail with all templates.
    But this is not so.
    Portfolio Joomla 2.5 is installed right.
    What is so special Joomla1.5 Portfolio?
    View as Sample _data BEGIN:

    ————————-
    TRUNCATE TABLE `#__banner`;

    —
    — Dumping data for table `j2d884_banner`
    —

    INSERT INTO `#__banner` (`bid`, `cid`, `type`, `name`, `alias`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`, `catid`, `description`, `sticky`, `ordering`, `publish_up`, `publish_down`, `tags`, `params`) VALUES
    (1, 1, ‘banner’, ‘OSM 1’, ‘osm-1’, 0, 43, 0, ‘osmbanner1.png’, ‘http://www.opensourcematters.org’, ‘2004-07-07 15:31:29’, 1, 0, ‘0000-00-00 00:00:00’, ”, ”, 13, ”, 0, 1, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”),
    (2, 1, ‘banner’, ‘OSM 2’, ‘osm-2’, 0, 49, 0, ‘osmbanner2.png’, ‘http://www.opensourcematters.org’, ‘2004-07-07 15:31:29’, 1, 0, ‘0000-00-00 00:00:00’, ”, ”, 13, ”, 0, 2, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”),
    (3, 1, ”, ‘Joomla!’, ‘joomla’, 0, 292, 0, ”, ‘http://www.joomla.org’, ‘2006-05-29 14:21:28’, 1, 0, ‘0000-00-00 00:00:00’, ”, ‘<a href=”{CLICKURL}” target=”_blank”>{NAME}</a>rn<br/>rnJoomla! The most popular and widely used Open Source CMS Project in the world.’, 14, ”, 0, 1, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”),
    (4, 1, ”, ‘JoomlaCode’, ‘joomlacode’, 0, 292, 0, ”, ‘http://joomlacode.org’, ‘2006-05-29 14:19:26’, 1, 0, ‘0000-00-00 00:00:00’, ”, ‘<a href=”{CLICKURL}” target=”_blank”>{NAME}</a>rn<br/>rnJoomlaCode, development and distribution made easy.’, 14, ”, 0, 2, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”),
    (5, 1, ”, ‘Joomla! Extensions’, ‘joomla-extensions’, 0, 287, 0, ”, ‘http://extensions.joomla.org’, ‘2006-05-29 14:23:21’, 1, 0, ‘0000-00-00 00:00:00’, ”, ‘<a href=”{CLICKURL}” target=”_blank”>{NAME}</a>rn<br/>rnJoomla! Components, Modules, Plugins and Languages by the bucket load.’, 14, ”, 0, 3, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”),
    (6, 1, ”, ‘Joomla! Shop’, ‘joomla-shop’, 0, 287, 0, ”, ‘http://shop.joomla.org’, ‘2006-05-29 14:23:21’, 1, 0, ‘0000-00-00 00:00:00’, ”, ‘<a href=”{CLICKURL}” target=”_blank”>{NAME}</a>rn<br/>rnFor all your Joomla! merchandise.’, 14, ”, 0, 4, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”),
    (7, 1, ”, ‘Joomla! Promo Shop’, ‘joomla-promo-shop’, 0, 19, 1, ‘shop-ad.jpg’, ‘http://shop.joomla.org’, ‘2007-09-19 17:26:24’, 1, 0, ‘0000-00-00 00:00:00’, ”, ”, 33, ”, 0, 3, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”),
    (8, 1, ”, ‘Joomla! Promo Books’, ‘joomla-promo-books’, 0, 14, 0, ‘shop-ad-books.jpg’, ‘http://shop.joomla.org/amazoncom-bookstores.html’, ‘2007-09-19 17:28:01’, 1, 0, ‘0000-00-00 00:00:00’, ”, ”, 33, ”, 0, 4, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”);

    TRUNCATE TABLE `#__bannerclient`;

    —
    — Dumping data for table `j2d884_bannerclient`
    —
    …..
    …..
    ….

    ————————–
    This Sample_data can not be normal.

    pixelzombie Friend
    March 27, 2012 at 11:15 pm #446022

    Hi carlucci,

    I really can’t tell you why this issue only happens with the Portfolio J1.5 Template.
    However, could you please try to use the latest XAMPP http://www.apachefriends.org/en/xampp.html and see if that works for you? It’s the only idea that I have at this moment. If we can’t find a solution for this issue, I’ll forward this to the JA Devs.

    Cheers and thanks for your patience!

    Frank

    carlucci Friend
    April 15, 2012 at 9:44 am #448430

    Notice to Mr. Hung Dinh.
    The moderators do not know the problem that worries me.
    See this post:

    It is obvious that the ruling is Joomlart.
    The file is truncated .

    Is it so difficult to change the damaged file with a good one?

    I do not understand how Joomlart, not knowing how to solve a small correction.
    I have to put other messages, but given that the moderators do not care, I will wait to end my subscription and I will take action.

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 22 total)
1 2

This topic contains 22 replies, has 7 voices, and was last updated by  zombiesonice 12 years, 3 months ago.

We moved to new unified forum. Please post all new support queries in our New Forum

Important Notice :

New Unified Portal is live

Must Read

Jump to forum

Categories