1064 error when I install the quick start

Viewing 14 posts - 1 through 14 (of 14 total)

Author

Posts
Fernando Ribeiro Friend

Fernando Ribeiro
Join date:
December 2012
Posts:
23
Downloads:
79
Uploads:
17

Thanks:

4

December 19, 2015 at 9:57 pm #823186

Hi. It is the second time I installed Ja Events II. And I installed in two different servers and in both I have a 1064 error when I create categories and articles.

In one server is this:
"1064 Você tem um erro de sintaxe no seu SQL próximo a ‘AND sha1_hash = ‘a1ec1d8c4379c7e282184c97cb2f5e490ec7ad88′ LIMIT 0, 1’ na linha 3 SQL=SELECT * FROM xgzka_ucm_history WHERE ucm_item_id = 30 AND ucm_type_id = AND sha1_hash = ‘a1ec1d8c4379c7e282184c97cb2f5e490ec7ad88’ LIMIT 0, 1"

"Você tem um erro de sintaxe no seu SQL próximo a " = "You have an error in your SQL syntax"

In other server is this
" 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘AND sha1_hash = ‘d0333380fe38412edf91654e32b0acc7df7078b2′ LIMIT 0, 1’ at line 3 SQL=SELECT * FROM iezbl_ucm_history WHERE ucm_item_id = 30 AND ucm_type_id = AND sha1_hash = ‘d0333380fe38412edf91654e32b0acc7df7078b2’ LIMIT 0, 1"

This second server was a test server and I changed for the official but it have this error. And I don’t know why have this error, because it’s a new database and I worked with quickstart install directly.

I hope somebody can help me

Ninja Lead Moderator

Ninja Lead
Join date:
November 2014
Posts:
16064
Downloads:
310
Uploads:
2864

Thanks:

341

Thanked:

3854 times in 3563 posts

December 21, 2015 at 3:44 am #826345

Hi,

You can try to change the collation of database of your site via hosting to utf8_general_ci and re-install quickstart installation again, let me know if it helps

Regards

Fernando Ribeiro Friend

Fernando Ribeiro
Join date:
December 2012
Posts:
23
Downloads:
79
Uploads:
17

Thanks:

4

December 22, 2015 at 1:27 am #828059

Dear Ninja…

I changed the collation of database to utf8_general_ci and installed the quick start again and the error continues:

"1064 Você tem um erro de sintaxe no seu SQL próximo a ‘AND sha1_hash = ‘8d3621e5a069019e3c27e166aa25fcd10b1a9c07′ LIMIT 0, 1’ na linha 3 SQL=SELECT * FROM mre5i_ucm_history WHERE ucm_item_id = 30 AND ucm_type_id = AND sha1_hash = ‘8d3621e5a069019e3c27e166aa25fcd10b1a9c07’ LIMIT 0, 1"

Thanks,

Fernando Ribeiro

Ninja Lead Moderator

Ninja Lead
Join date:
November 2014
Posts:
16064
Downloads:
310
Uploads:
2864

Thanks:

341

Thanked:

3854 times in 3563 posts

December 22, 2015 at 3:05 am #828154

I downloaded JA Event II quickstart package and installed it at my end and it’s working fine, you can give me the URL of your site and cpanel account of your hosting via your reply and Set as private reply, I will check the problem directly from your hosting.

Fernando Ribeiro Friend

Fernando Ribeiro
Join date:
December 2012
Posts:
23
Downloads:
79
Uploads:
17

Thanks:

4

January 11, 2016 at 7:14 pm #844596

This reply has been marked as private.
Ninja Lead Moderator

Ninja Lead
Join date:
November 2014
Posts:
16064
Downloads:
310
Uploads:
2864

Thanks:

341

Thanked:

3854 times in 3563 posts
January 12, 2016 at 4:05 am #845061
As I can see that there is not much update on your site so please try to download and install the Quickstart package of this template again. Here are some steps you can follow:
- Create a new database and set database collation to utf8_general_ci
- Install Quickstart package but please INSTALL SAMPLE DATA (you can remove data later)
- In case that you don’t want to use sample data, please install Joomla package instead of quickstart package, then install JA Events II template and its complimentary extension.
Once done with installation, try to make change again and let me know how it goes.
Attachments:
Fernando Ribeiro Friend

Fernando Ribeiro
Join date:
December 2012
Posts:
23
Downloads:
79
Uploads:
17

Thanks:

4

January 13, 2016 at 9:06 pm #847024

Thanks Ninja!

I’m doing this today… soon I’m having more news.

Thanks again!

Fernando Ribeiro Friend

Fernando Ribeiro
Join date:
December 2012
Posts:
23
Downloads:
79
Uploads:
17

Thanks:

4

January 14, 2016 at 8:14 pm #848078

This reply has been marked as private.
Ninja Lead Moderator

Ninja Lead
Join date:
November 2014
Posts:
16064
Downloads:
310
Uploads:
2864

Thanks:

341

Thanked:

3854 times in 3563 posts
January 15, 2016 at 4:18 am #848305
I enabled the debug language from backend of your site and saw the language is not loading on your site, see the screenshot

I uploaded both files and you can get it and copy them into path below
```
templates/jaeventsii/language/en-GB/en-GB.tpl_jaeventsii.sys.ini
language/en-GB/en-GB.tpl_jaeventsii.sys.ini
templates/jaeventsii/language/en-GB/en-GB.tpl_jaeventsii.ini
language/en-GB/en-GB.tpl_jaeventsii.ini
```
Hope it helps
Attachments:

Archive.zip
Fernando Ribeiro Friend

Fernando Ribeiro
Join date:
December 2012
Posts:
23
Downloads:
79
Uploads:
17

Thanks:

4
January 15, 2016 at 11:19 am #848599
Dear Ninja,

thank you again. But it’s not working. I saw the files and I copied again in the paths and nothing. It’s not load the language.

I’m having the problem of template in with JAEM too. And the ACM modules are not working as demo.

I believe I’ll erase everything and try to install the quick start again. And try to fix that 1064 error. Because now I having a lot of problems . And I’m really like of this template. It is i need now…

will see. Thank you.
Attachments:
Ninja Lead Moderator

Ninja Lead
Join date:
November 2014
Posts:
16064
Downloads:
310
Uploads:
2864

Thanks:

341

Thanked:

3854 times in 3563 posts
January 18, 2016 at 6:47 am #851330
Please look at my screenshot and could not see the language files to load on your site. You can give me the FTP account of your hosting via Set as private reply. I will help you to check this bug.

About the problem with JAEM component, pls give it a try again.
Attachments:
Fernando Ribeiro Friend

Fernando Ribeiro
Join date:
December 2012
Posts:
23
Downloads:
79
Uploads:
17

Thanks:

4

January 18, 2016 at 12:27 pm #851753

This reply has been marked as private.
Ninja Lead Moderator

Ninja Lead
Join date:
November 2014
Posts:
16064
Downloads:
310
Uploads:
2864

Thanks:

341

Thanked:

3854 times in 3563 posts
January 19, 2016 at 2:45 pm #855049
Hi
About the problem JA Event II template from JAEM component on your site, you can do it by the given steps below :
- Make a backup version on your site.
- Go to download page and get JA Events II template.
- Install JA Events II template directly on your site
If you have any further assistance please don’t hesitate to contact us.
Fernando Ribeiro Friend

Fernando Ribeiro
Join date:
December 2012
Posts:
23
Downloads:
79
Uploads:
17

Thanks:

4

January 27, 2016 at 1:51 am #869296

Thank you Ninja! Now it’s everything ok. I’m working in the website. Thanks, so much!
Author

Posts

Viewing 14 posts - 1 through 14 (of 14 total)

This topic contains 13 replies, has 2 voices, and was last updated by Fernando Ribeiro 8 years, 9 months ago.

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

Quick Navigation

Site navigation

1064 error when I install the quick start

Fernando Ribeiro

Ninja Lead

Fernando Ribeiro

Ninja Lead

Fernando Ribeiro

Ninja Lead

Fernando Ribeiro

Fernando Ribeiro

Ninja Lead

Fernando Ribeiro

Ninja Lead

Fernando Ribeiro

Ninja Lead

Fernando Ribeiro

Important Notice :

Jump to forum

Categories