hakana VIP
Total posts: 425
09 Oct 2014 14:00

Hi Sergey,

When I try to upload the package 294 package, I get the error below:

The only thing that I have changed on this table is renaming Turkey as Türkiye before.

Column count doesn't match value count at row 1 SQL=INSERT INTO j33_emerald_country VALUES ('AD', 'Andorra'), ('AE', 'United Arab Emirates'), ('AF', 'Afghanistan'), ('AG', 'Antigua and Barbuda'), ('AI', 'Anguilla'), ('AL', 'Albania'), ('AM', 'Armenia'), ('AN', 'Netherlands Antilles'), ('AO', 'Angola'), ('AQ', 'Antarctica'), ('AR', 'Argentina'), ('AS', 'American Samoa'), ('AT', 'Austria'), ('AU', 'Australia'), ('AW', 'Aruba'), ('AX', 'Åland Islands'), ('AZ', 'Azerbaijan'), ('BA', 'Bosnia and Herzegovina'), ('BB', 'Barbados'), ('BD', 'Bangladesh'), ('BE', 'Belgium'), ('BF', 'Burkina Faso'), ('BG', 'Bulgaria'), ('BH', 'Bahrain'), ('BI', 'Burundi'), ('BJ', 'Benin'), ('BL', 'Saint Barthélemy'), ('BM', 'Bermuda'), ('BN', 'Brunei'), ('BO', 'Bolivia'), ('BQ', 'British Antarctic Territory'), ('BR', 'Brazil'), ('BS', 'Bahamas'), ('BT', 'Bhutan'), ('BV', 'Bouvet Island'), ('BW', 'Botswana'), ('BY', 'Belarus'), ('BZ', 'Belize'), ('CA', 'Canada'), ('CC', 'Cocos [Keeling] Islands'), ('CD', 'Congo - Kinshasa'), ('CF', 'Central African Republic'), ('CG', 'Congo - Brazzaville'), ('CH', 'Switzerland'), ('CI', 'Côte d’Ivoire'), ('CK', 'Cook Islands'), ('CL', 'Chile'), ('CM', 'Cameroon'), ('CN', 'China'), ('CO', 'Colombia'), ('CR', 'Costa Rica'), ('CS', 'Serbia and Montenegro'), ('CT', 'Canton and Enderbury Islands'), ('CU', 'Cuba'), ('CV', 'Cape Verde'), ('CX', 'Christmas Island'), ('CY', 'Cyprus'), ('CZ', 'Czech Republic'), ('DD', 'East Germany'), ('DE', 'Germany'), ('DJ', 'Djibouti'), ('DK', 'Denmark'), ('DM', 'Dominica'), ('DO', 'Dominican Republic'), ('DZ', 'Algeria'), ('EC', 'Ecuador'), ('EE', 'Estonia'), ('EG', 'Egypt'), ('EH', 'Western Sahara'), ('ER', 'Eritrea'), ('ES', 'Spain'), ('ET', 'Ethiopia'), ('FI', 'Finland'), ('FJ', 'Fiji'), ('FK', 'Falkland Islands'), ('FM', 'Micronesia'), ('FO', 'Faroe Islands'), ('FQ', 'French Southern and Antarctic Territories'), ('FR', 'France'), ('FX', 'Metropolitan France'), ('GA', 'Gabon'), ('GB', 'United Kingdom'), ('GD', 'Grenada'), ('GE', 'Georgia'), ('GF', 'French Guiana'), ('GG', 'Guernsey'), ('GH', 'Ghana'), ('GI', 'Gibraltar'), ('GL', 'Greenland'), ('GM', 'Gambia'), ('GN', 'Guinea'), ('GP', 'Guadeloupe'), ('GQ', 'Equatorial Guinea'), ('GR', 'Greece'), ('GS', 'South Georgia and the South Sandwich Islands'), ('GT', 'Guatemala'), ('GU', 'Guam'), ('GW', 'Guinea-Bissau'), ('GY', 'Guyana'), ('HK', 'Hong Kong SAR China'), ('HM', 'Heard Island and McDonald Islands'), ('HN', 'Honduras'), ('HR', 'Croatia'), ('HT', 'Haiti'), ('HU', 'Hungary'), ('ID', 'Indonesia'), ('IE', 'Ireland'), ('IL', 'Israel'), ('IM', 'Isle of Man'), ('IN', 'India'), ('IO', 'British Indian Ocean Territory'), ('IQ', 'Iraq'), ('IR', 'Iran'), ('IS', 'Iceland'), ('IT', 'Italy'), ('JE', 'Jersey'), ('JM', 'Jamaica'), ('JO', 'Jordan'), ('JP', 'Japan'), ('JT', 'Johnston Island'), ('KE', 'Kenya'), ('KG', 'Kyrgyzstan'), ('KH', 'Cambodia'), ('KI', 'Kiribati'), ('KM', 'Comoros'), ('KN', 'Saint Kitts and Nevis'), ('KP', 'North Korea'), ('KR', 'South Korea'), ('KW', 'Kuwait'), ('KY', 'Cayman Islands'), ('KZ', 'Kazakhstan'), ('LA', 'Laos'), ('LB', 'Lebanon'), ('LC', 'Saint Lucia'), ('LI', 'Liechtenstein'), ('LK', 'Sri Lanka'), ('LR', 'Liberia'), ('LS', 'Lesotho'), ('LT', 'Lithuania'), ('LU', 'Luxembourg'), ('LV', 'Latvia'), ('LY', 'Libya'), ('MA', 'Morocco'), ('MC', 'Monaco'), ('MD', 'Moldova'), ('ME', 'Montenegro'), ('MF', 'Saint Martin'), ('MG', 'Madagascar'), ('MH', 'Marshall Islands'), ('MI', 'Midway Islands'), ('MK', 'Macedonia'), ('ML', 'Mali'), ('MM', 'Myanmar [Burma]'), ('MN', 'Mongolia'), ('MO', 'Macau SAR China'), ('MP', 'Northern Mariana Islands'), ('MQ', 'Martinique'), ('MR', 'Mauritania'), ('MS', 'Montserrat'), ('MT', 'Malta'), ('MU', 'Mauritius'), ('MV', 'Maldives'), ('MW', 'Malawi'), ('MX', 'Mexico'), ('MY', 'Malaysia'), ('MZ', 'Mozambique'), ('NA', 'Namibia'), ('NC', 'New Caledonia'), ('NE', 'Niger'), ('NF', 'Norfolk Island'), ('NG', 'Nigeria'), ('NI', 'Nicaragua'), ('NL', 'Netherlands'), ('NO', 'Norway'), ('NP', 'Nepal'), ('NQ', 'Dronning Maud Land'), ('NR', 'Nauru'), ('NT', 'Neutral Zone'), ('NU', 'Niue'), ('NZ', 'New Zealand'), ('OM', 'Oman'), ('PA', 'Panama'), ('PC', 'Pacific Islands Trust Territory'), ('PE', 'Peru'), ('PF', 'French Polynesia'), ('PG', 'Papua New Guinea'), ('PH', 'Philippines'), ('PK', 'Pakistan'), ('PL', 'Poland'), ('PM', 'Saint Pierre and Miquelon'), ('PN', 'Pitcairn Islands'), ('PR', 'Puerto Rico'), ('PS', 'Palestinian Territories'), ('PT', 'Portugal'), ('PU', 'U.S. Miscellaneous Pacific Islands'), ('PW', 'Palau'), ('PY', 'Paraguay'), ('PZ', 'Panama Canal Zone'), ('QA', 'Qatar'), ('RE', 'Réunion'), ('RO', 'Romania'), ('RS', 'Serbia'), ('RU', 'Russia'), ('RW', 'Rwanda'), ('SA', 'Saudi Arabia'), ('SB', 'Solomon Islands'), ('SC', 'Seychelles'), ('SD', 'Sudan'), ('SE', 'Sweden'), ('SG', 'Singapore'), ('SH', 'Saint Helena'), ('SI', 'Slovenia'), ('SJ', 'Svalbard and Jan Mayen'), ('SK', 'Slovakia'), ('SL', 'Sierra Leone'), ('SM', 'San Marino'), ('SN', 'Senegal'), ('SO', 'Somalia'), ('SR', 'Suriname'), ('ST', 'São Tomé and Príncipe'), ('SU', 'Union of Soviet Socialist Republics'), ('SV', 'El Salvador'), ('SY', 'Syria'), ('SZ', 'Swaziland'), ('TC', 'Turks and Caicos Islands'), ('TD', 'Chad'), ('TF', 'French Southern Territories'), ('TG', 'Togo'), ('TH', 'Thailand'), ('TJ', 'Tajikistan'), ('TK', 'Tokelau'), ('TL', 'Timor-Leste'), ('TM', 'Turkmenistan'), ('TN', 'Tunisia'), ('TO', 'Tonga'), ('TR', 'Turkey'), ('TT', 'Trinidad and Tobago'), ('TV', 'Tuvalu'), ('TW', 'Taiwan'), ('TZ', 'Tanzania'), ('UA', 'Ukraine'), ('UG', 'Uganda'), ('UM', 'U.S. Minor Outlying Islands'), ('US', 'United States'), ('UY', 'Uruguay'), ('UZ', 'Uzbekistan'), ('VA', 'Vatican City'), ('VC', 'Saint Vincent and the Grenadines'), ('VD', 'North Vietnam'), ('VE', 'Venezuela'), ('VG', 'British Virgin Islands'), ('VI', 'U.S. Virgin Islands'), ('VN', 'Vietnam'), ('VU', 'Vanuatu'), ('WF', 'Wallis and Futuna'), ('WK', 'Wake Island'), ('WS', 'Samoa'), ('YD', 'Peoples Democratic Republic of Yemen'), ('YE', 'Yemen'), ('YT', 'Mayotte'), ('ZA', 'South Africa'), ('ZM', 'Zambia'), ('ZW', 'Zimbabwe'), ('ZZ', 'Unknown or Invalid Region');

Last Modified: 07 Sep 2021


hakana VIP
Total posts: 425
09 Oct 2014 14:41

The strange thing is, the files seem to be updated but the Emerald version shows the previous version. I think the database is not updated in this case. The site is screwed up and the buy now button does not work, giving this error:

1054 - Unknown column 'id' in 'where clause' SQL=SELECT name FROM j33_emerald_country WHERE id = 'TR'

I have reinstalled the previous package but the error is not fixed.


hakana VIP
Total posts: 425
09 Oct 2014 15:07

The issue is ID column on country table strangely disappeard with this version. Therefore the countrynames cannot be updated. I have manually added Türkiye as the country, but the other countries are still missing. I would really appreciate if you could release a new version with a fix. I have no idea what version I am using now, because of installing the current version and the prevous version multi times.


pepperstreet VIP
Total posts: 3,837
09 Oct 2014 17:50

Confirmed!

Got the same issue with latest Emerald release. Updated from previous version. Error 1136


hakana VIP
Total posts: 425
09 Oct 2014 19:18

Unfortunately, I cannot fix the table by installing the previous version. The table becomes empty.


pepperstreet VIP
Total posts: 3,837
09 Oct 2014 23:42

You are right, there is only a NAME column.

hakana Unfortunately, I cannot fix the table by installing the previous version. The table becomes empty.

  • renamed the emerald country table
  • reInstalled previous Emerald package
  • table is created with ID, NAME. But is is EMPTY.

Maybe an issue with the new update scheme/method...

Sorry, no idea. We have to wait for Sergey's answer and help...


Have sent a Skype msg ;)


Jeff VIP
Total posts: 745
10 Oct 2014 00:00

hakana Unfortunately, I cannot fix the table by installing the previous version. The table becomes empty.

Same here :-(


Sergey
Total posts: 13,748
10 Oct 2014 01:31

Delete country table and then install Emerald again. I am working on new update.


Sergey
Total posts: 13,748
10 Oct 2014 01:41

Updated. v 9.295. Please check.


pepperstreet VIP
Total posts: 3,837
10 Oct 2014 02:48

Sergey Updated. v 9.295. Please check.

Seems to work :)

Message  
Successful update: ALTER TABLE `j30_emerald_country` CHANGE COLUMN `id` `id` CHAR(2) NOT NULL DEFAULT '' COMMENT ''  
Installing package was successful.

hakana VIP
Total posts: 425
10 Oct 2014 06:30

Yeah, mine works too. I had to define id as primary key though. Thank you Sergey for your quick response.


enocasino VIP
Total posts: 33
10 Oct 2014 21:37

Just tried to install the latest emerald. Same error....tried installing on brand new joomla and new database...same error. Seriously, 100 bucks. When packages are posted as stable, does anyone actually try to install and run them?


Jeff VIP
Total posts: 745
10 Oct 2014 22:19

Sergey Updated. v 9.295. Please check.

Seems to work, but when I try to view analytics it only shows: No data in DB :-(

Very strange, because the sales page tells me there are more than plenty of sales.....


Jeff VIP
Total posts: 745
10 Oct 2014 22:24

enocasino Just tried to install the latest emerald. Same error....tried installing on brand new joomla and new database...same error.

Yes, that happens to me sometimes when I try to upload a bug fix version.

Try installing an older version (one that properly installs) and update it with the latest version. You may have to drop table j30_emerald_country first though.


hakana VIP
Total posts: 425
11 Oct 2014 06:46

When I had the error, I manually added the id column that was removed and defined it as primary. Then did the installation and it worked. Please do so by using phpmyadmin. Then install the latest version. As far as I see the last version does not check if any of the columns are removed or the whole counrty table had been removed. If you add the missing column manually, the update will work.


Sergey
Total posts: 13,748
12 Oct 2014 03:16

enocasino Just tried to install the latest emerald. Same error....tried installing on brand new joomla and new database...same error. Seriously, 100 bucks. When packages are posted as stable, does anyone actually try to install and run them?

Please try my instuction. Delete _emerald_country table and install Emerald over.

This is our fist troubled Emerald update for last 3 years. This happence sometimes. I apologize for this. But on the other hand, there is no software without bugs or errors sometimes. But anyway I'll try to be more attantive next time.

hakana As far as I see the last version does not check if any of the columns are removed or the whole counrty table had been removed.

Actualy last update removes country table before istall without checking if it is correct or not. First we remove it in any case, and then start installation.


hakana VIP
Total posts: 425
12 Oct 2014 14:28

Sergey This is our fist troubled Emerald update for last 3 years. This happence sometimes. I apologize for this. But on the other hand, there is no software without bugs or errors sometimes. But anyway I'll try to be more attantive next time.

Actually I have been using this component for many months and I was telling this to one of my colleagues: It is the most bugless component I have ever used. There is a new release every week. I respect Sergey's efforts to develop this extension.

Powered by Cobalt