chilly_orange

chilly_orange supports this item

Supported

This author's response time can be up to 5 business days.

Popular questions for this item

My currencies are showing all messed up, how come?

This is caused by the “currencies” table in your Innvoice database using an encoding different then UTF8 (it should have a UTF-8 encoding). To solve this; delete the current “currencies” table and execute the following SQL to re-create the table with the proper encoding:

CREATE TABLE `currencies` ( `currency_id` int(11) NOT NULL AUTO_INCREMENT, `currency_shortname` varchar(20) NOT NULL, `currency_fullname` varchar(255) NOT NULL, `currency_sign` varchar(10) NOT NULL, PRIMARY KEY (`currency_id`), UNIQUE KEY `currency_shortname` (`currency_shortname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=113 ; -- -- Dumping data for table `currencies` -- INSERT INTO `currencies` (`currency_id`, `currency_shortname`, `currency_fullname`, `currency_sign`) VALUES (1, 'USD', 'United States', '$'), (2, 'EUR', 'Euro', '€'), (3, 'GBP', 'United Kingdom', '£'), (4, 'AUD', 'Australia', '$'), (5, 'CNY', 'China', '¥'), (6, 'DKK', 'Denmark', 'kr'), (7, 'HKD', 'Hong Kong', '$'), (8, 'INR', 'India', '₹'), (9, 'JPY', 'Japan', '¥'), (10, 'KRW', 'South Korea', '₩'), (11, 'NZD', 'New Zealand', '$'), (12, 'NOK', 'Norway', 'kr'), (13, 'RUB', 'Russia', 'руб'), (14, 'SGD', 'Singapore', '$'), (15, 'ZAR', 'South Africa', 'S'), (16, 'SEK', 'Sweden', 'kr'), (17, 'CHF', 'Switzerland', 'CHF'), (18, 'TWD', 'Taiwan', 'NT$'), (19, 'THB', 'Thailand', '฿'), (20, 'TRL', 'Turkey', '₤'), (21, 'BRL', 'Brazil', 'R$'), (22, 'ALL', 'Albania', 'Lek'), (23, 'AFN', 'Afghanistan', '؋'), (24, 'ARS', 'Argentina', '$'), (25, 'AWG', 'Aruba', 'ƒ'), (26, 'AZN', 'Azerbaijan', 'ман'), (27, 'BSD', 'Bahamas', '$'), (28, 'BBD', 'Barbados', '$'), (29, 'BYR', 'Belarus', 'p.'), (30, 'BZD', 'Belize', 'BZ$'), (31, 'BMD', 'Bermuda', '$'), (32, 'BOB', 'Bolivia', '$b'), (33, 'BAM', 'Bosnia and Herzegovina', 'KM'), (34, 'BWP', 'Botswana', 'P'), (35, 'BGN', 'Bulgaria', 'лв'), (36, 'BND', 'Brunei', '$'), (37, 'KHR', 'Cambodia', '៛'), (38, 'CAD', 'Canada', '$'), (39, 'KYD', 'Cayman', '$'), (40, 'CLP', 'Chile', '$'), (41, 'COP', 'Colombia', '$'), (42, 'CRC', 'Costa Rica', '₡'), (43, 'HRK', 'Croatia', 'kn'), (44, 'CUP', 'Cuba', '₱'), (45, 'CZK', 'Czech Republic', 'Kč'), (46, 'DOP', 'Dominican Republic', 'RD$'), (47, 'XCD', 'East Caribbean', '$'), (48, 'EGP', 'Egypt', '£'), (49, 'SVC', 'El Salvador', '$'), (50, 'EEK', 'Estonia', 'kr'), (51, 'FKP', 'Falkland Islands', '£'), (52, 'FJD', 'Fiji', '$'), (53, 'GHC', 'Ghana', '¢'), (54, 'GIP', 'Gibraltar', '£'), (55, 'GTQ', 'Guatemala', 'Q'), (56, 'GGP', 'Guernsey', '£'), (57, 'GYD', 'Guyana', '$'), (58, 'HNL', 'Honduras', 'L'), (59, 'HUF', 'Hungary', 'Ft'), (60, 'ISK', 'Iceland', 'kr'), (61, 'IDR', 'Indonesia', 'Rp'), (62, 'IRR', 'Iran', '﷼'), (63, 'IMP', 'Isle Of Man', '£'), (64, 'ILS', 'Israel', '₪'), (65, 'JMD', 'Jamaica', '$'), (66, 'JEP', 'Jersey', '£'), (67, 'KZT', 'Kazakhstan', 'лв'), (68, 'KPW', 'North Korea', '₩'), (69, 'KGS', 'Kyrgyzstan', 'лв'), (70, 'LAK', 'Laos', '₭'), (71, 'LVL', 'Latvia', 'Ls'), (72, 'LBP', 'Lebanon', '£'), (73, 'LRD', 'Liberia', '$'), (74, 'LTL', 'Lithuania', 'Lt'), (75, 'MKD', 'Macedonia', 'ден'), (76, 'MYR', 'Malaysia', 'RM'), (77, 'MUR', 'Mauritius', 'Rs'), (78, 'MXN', 'Mexico', '$'), (79, 'MNT', 'Mongolia', '₮'), (80, 'MZN', 'Mozambique', 'MT'), (81, 'NAD', 'Namibia', '$'), (82, 'NPR', 'Nepal', '₨'), (83, 'ANG', 'Netherlands', 'ƒ'), (84, 'NIO', 'Nicaragua', 'C$'), (85, 'NGN', 'Nigeria', '₦'), (86, 'OMR', 'Oman', '﷼'), (87, 'PKR', 'Pakistan', '₨'), (88, 'PAB', 'Panama', 'B/.'), (89, 'PYG', 'Paraguay', 'Gs'), (90, 'PEN', 'Peru', 'S/.'), (91, 'PHP', 'Philippines', '₱'), (92, 'PLN', 'Poland', 'zł'), (93, 'QAR', 'Qatar', '﷼'), (94, 'RON', 'Romania', 'lei'), (95, 'SHP', 'Saint Helena', '£'), (96, 'SAR', 'Saudi Arabia', '﷼'), (97, 'RSD', 'Serbia', 'Дин.'), (98, 'SCR', 'Seychelles', '₨'), (99, 'SBD', 'Solomon Islands', '$'), (100, 'SOS', 'Somalia', 'S'), (101, 'LKR', 'Sri Lanka', '₨'), (102, 'SRD', 'Suriname', '$'), (103, 'SYP', 'Syria', '£'), (104, 'TTD', 'Trinidad and Tobago', 'TT$'), (105, 'TVD', 'Tuvalu', '$'), (106, 'UAH', 'Ukraine', '₴'), (107, 'UYU', 'Uruguay', '$U'), (108, 'UZS', 'Uzbekistan', 'лв'), (109, 'VEF', 'Venezuela', 'Bs'), (110, 'VND', 'Vietnam', '₫'), (111, 'YER', 'Yemen', '﷼'), (112, 'ZWD', 'Zimbabwe', 'Z$');

Contact the author

This author will respond to buyers' questions and provides limited support through their own support system.

Item support includes:

  • Availability of the author to answer questions
  • Answering technical questions about item’s features
  • Assistance with reported bugs and issues
  • Help with included 3rd party assets

However, item support does not include:

  • Customization services
  • Installation services

View the item support policy

by
by
by
by
by
by