- Posts: 12
- Thank you received: 0
unknown field
- Shiningworld
- Topic Author
- Offline
- New Member
-
Less
More
10 years 1 month ago #61733
by Shiningworld
unknown field was created by Shiningworld
I'm having a problem. When I go to my events page, I get the error below. When I look at the install.eventbooking.sql file in the package, there is no such field. it's like the tables and the component are out of sync. I recently updated to the latest 1.7.2. I'm having trouble reinstalling, all the files seem to go up, but I get an unknown file copy error at some point which seems to kill it. Seems I have an unrelated permissions problem somewhere. I was hoping to install the tables manually, but the field doesn't exist in the sql. Can you help? The admin seems to work fine as far as I can tell.
Code:
1054 - Unknown column 'tbl.registration_start_date' in 'field list' SQL=SELECT tbl.*,title AS title, short_description AS short_description_description, description AS description,DATEDIFF(tbl.early_bird_discount_date, '2015-04-24 06:50:54') AS date_diff,DATEDIFF(tbl.event_date, '2015-04-24 06:50:54') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.registration_start_date, '2015-04-24 06:50:54') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2015-04-24 06:50:54') AS cut_off_minutes,c.name AS location_name, c.address AS location_address,IFNULL(SUM(b.number_registrants), 0) AS total_registrants FROM ce23a_eb_events AS tbl LEFT JOIN ce23a_eb_registrants AS b ON (tbl.id = b.event_id AND b.group_id=0 AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" AND b.published NOT IN (2,3)))) LEFT JOIN ce23a_eb_locations AS c ON tbl.location_id = c.id WHERE tbl.published=1 AND tbl.access IN (1,1) AND DATE(tbl.event_date) >= "2015-04-24" GROUP BY tbl.id ORDER BY tbl.event_date ASC LIMIT 0, 3
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
10 years 1 month ago #61739
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic unknown field
Hi
It seems the field registration_start_date was not created during installation process for some reasons and it causes the issue. Could you please submit a support ticket sending us super admin account of your site? I am going to check to see what's wrong and get it sorted for you
Tuan
It seems the field registration_start_date was not created during installation process for some reasons and it causes the issue. Could you please submit a support ticket sending us super admin account of your site? I am going to check to see what's wrong and get it sorted for you
Tuan
Please Log in or Create an account to join the conversation.
- Shiningworld
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 12
- Thank you received: 0
10 years 1 month ago #61756
by Shiningworld
Replied by Shiningworld on topic unknown field
I reverted the the component to the old version and it's back up. I imagine the copy file error is killing the installation process and the installation script never gets far enough to update the tables. I'll try again after I hunt down that permission problem.
thanks
thanks
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
10 years 1 month ago #61759
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic unknown field
A way to update database schema to latest version is access to this URL (after you logged in to backend of your site):
Of course domain.com needs to be replaced with your site domain
Tuan
Code:
http://domain.com/administrator/index.php?option=com_eventbooking&task=update_db_schema&install_type=update
Of course domain.com needs to be replaced with your site domain
Tuan
Please Log in or Create an account to join the conversation.
- Jacqui
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
9 years 11 months ago #63857
by Jacqui
Replied by Jacqui on topic unknown field
Hi, I am having the very same problem. Can you help? The URL is
104.238.72.237/~mirepoixcs/
and you will have to add 104.238.72.237/~mirepoixcs to your HOSTS file to view the site.
J
J
Please Log in or Create an account to join the conversation.
- Jacqui
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
9 years 11 months ago #63859
by Jacqui
I tried visiting the URL you provided above and received this error: (attached)
Replied by Jacqui on topic also
Tuan Pham Ngoc wrote: A way to update database schema to latest version is access to this URL (after you logged in to backend of your site):
Code:http://domain.com/administrator/index.php?option=com_eventbooking&task=update_db_schema&install_type=update
Of course domain.com needs to be replaced with your site domain
Tuan
I tried visiting the URL you provided above and received this error: (attached)
- Tuan Pham Ngoc
- Offline
- Administrator
-
9 years 11 months ago #63895
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic also
Just want to update that we worked together via support ticket and got the issue sorted
Regards,
Tuan
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Timmermans & Partners
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
7 years 3 months ago #109949
by Timmermans & Partners
Replied by Timmermans & Partners on topic also have this problem
Hi I have this problem also on a website of a customer:
welift.nl.testbyte.nl/test/personal-training/test
How can i fix this?
How can i fix this?
Please Log in or Create an account to join the conversation.
- Shiningworld
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 12
- Thank you received: 0
7 years 3 months ago #109950
by Shiningworld
Replied by Shiningworld on topic also have this problem
Tuan's fix is to update the schema (see above). It worked without a hitch for me.
Please Log in or Create an account to join the conversation.
- Timmermans & Partners
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
7 years 3 months ago #109951
by Timmermans & Partners
Replied by Timmermans & Partners on topic also have this problem
Doesn't solve it for me unfortunately
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.