JA Job Board Component 8,554 posts

[zealze Friend zealzeJoin date: November 2009Posts: 103Downloads:0Uploads:32 Thanks: 22]

#146659

Hi,

I have a few errors when rebuilding db (Form Customization). It shows the following message:
1. message “Error Updating The Table” –> What should I do to fix it ?? :((
2. message “Successfully updated table” but the fields are still in red and don’t show up for front-end user. :confused:

These errors appeared in resume form. Please kindly check the red fields and fix them asap 😮

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#325981

Hi zealze,

Thank you for the report.

We are inspecting on the issue and shall give you the answer ASAP.

[zealze Friend zealzeJoin date: November 2009Posts: 103Downloads:0Uploads:32 Thanks: 22]

#326032

Thank you for your attention.
I’m looking forward to hear from you soon.
Hopefully you could fix this in no-time since I’m about to overdue the launch of my website. 🙁

Cheers !!! 🙂

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#326159

Hi again,

Thank you for your patience so far.

I would like to answer your questions as below:

1. message “Error Updating The Table” –> What should I do to fix it ?? :((

We have checked and could see that your mysql database is not updated to version 5.0.3 yet. This version only supports data VARCHAR (max length = 255). Meanwhile, with Jobboard, upon adding one filed (if in form of TEXTFIELD ) shall require mysql VARCHAR (max length 525)(Mysql version 5.0.3 or more). There are 2 solutions for this:
– You upgrade your mysql to version 5.0.3 or more
– You reset FTP account so that we can have full permission to modify JB files and fix this error

2. message “Successfully updated table” but the fields are still in red and don’t show up for front-end user. :confused:

We shall update the wrong message within new version soon.

The error is caused because the field_name of newly created one has existed within database already.

In this case, kindly go to database, check if there is any field that has the same name with the field you have created within Form customization or not. If exists, please remove it from database or rename the newly created field so that database could be successfully rebuilt.

1 user says Thank You to JA Developer for this useful post

1. zealze

[zealze Friend zealzeJoin date: November 2009Posts: 103Downloads:0Uploads:32 Thanks: 22]

#326314

Hi,

Thank you very much for your prompt response. 😎
I forwarded your answer to the team who handle the database already.
Hopefully, they could fix it. Otherwise, I will have to come back to you again.

[zealze Friend zealzeJoin date: November 2009Posts: 103Downloads:0Uploads:32 Thanks: 22]

#327104

Hi again,

I still have problems with rebuilding db especially with ‘single select’ & ‘text field’ field types.
I tried change the very same field to text area and rebuild db. There’s no problem at all.
Please kindly suggest how to fix this problem asap.

ps. I have purchased this component for a month already but still couldn’t get it right. If I still couldn’t get it all right by the end of 3 months, I probably feel like being cheated. This is my personal opinion only. Hope you understand me.

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#327148

Hi there,

Please reset permission so that I can save the revision to Job Board files. This can be fixed very shortly

[zealze Friend zealzeJoin date: November 2009Posts: 103Downloads:0Uploads:32 Thanks: 22]

#327416

<em>@JA Developer 157586 wrote:</em><blockquote>Hi there,

Please reset permission so that I can save the revision to Job Board files. This can be fixed very shortly</blockquote>

Hi,

My server administrater asked what are the changes needed.
Please specify root/folder(s) you want access to make change(s).

ps. ASAP please 🙂

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#327461

Hi,

Please grant us full permission for both Job Board folders including front end and back-end.

[zealze Friend zealzeJoin date: November 2009Posts: 103Downloads:0Uploads:32 Thanks: 22]

#327504

Please refer to the information I submitted with this topic.
Otherwise, please suggest how to give the requested information to you.

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#327570

Hi there

I have checked this table and saw that you have inserted 72 fields and some fields stored in a large size.It exceeds the size of row in table of mysql which mysql allows.

To solve this issue, you have to decrease the size of fields which have varchar type to 255 or change to text or blob type. At that time, you can add more fields in your table.

Hope you understand my explanation.

[zealze Friend zealzeJoin date: November 2009Posts: 103Downloads:0Uploads:32 Thanks: 22]

#327670

<em>@JA Developer 158107 wrote:</em><blockquote>Hi there

I have checked this table and saw that you have inserted 72 fields and some fields stored in a large size.It exceeds the size of row in table of mysql which mysql allows.

To solve this issue, you have to decrease the size of fields which have varchar type to 255 or change to text or blob type. At that time, you can add more fields in your table.

Hope you understand my explanation.</blockquote>

I tried to find the cause and change it.
Unfortunately, I couldn’t understand your explanation :confused:
Could you please specify where & how to fix ?? :((
It quite frustrated to unable to change radio button to single select…..

[zealze Friend zealzeJoin date: November 2009Posts: 103Downloads:0Uploads:32 Thanks: 22]

#327676

<em>@zealze 158255 wrote:</em><blockquote>I tried to find the cause and change it.
Unfortunately, I couldn’t understand your explanation :confused:
Could you please specify where & how to fix ?? :((
It quite frustrated to unable to change radio button to single select…..</blockquote>

Hi again,

I accidentially deleted ‘master university’ field which is needed for resume form.
The field is ‘single select’ type…… I cannot rebuild db for this.
Everytime I do, it keeps saying “Error updating table”….. Don’t know what to do know. :((

What even worst is when I want to change phone number from “integer” to “text field”, it won’t allow me. The message appears “Error updating table”……. OMG !!!! >:(

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#327764

Hi zealze

I have checked your database and saw that you have not changed as my explanation(http://www.joomlart.com/forums/showpost.php?p=156259&postcount=4)

in jos_ja_resumes table , I have just changed some fields which are using varchar type from 525 to 255 and then rebuild some fields in Forms customization. It it working fine.

1 user says Thank You to JA Developer for this useful post

1. zealze

[zealze Friend zealzeJoin date: November 2009Posts: 103Downloads:0Uploads:32 Thanks: 22]

#327940

Hi,

Thank you very much for your support.
It’s working properly now.

[Author]

Posts