Welcome, Guest
Username: Password: Remember me

TOPIC:

Change Date Format On Details Page 7 years 7 months ago #16925

  • Hoffi
  • Hoffi's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 2279
  • Thank you received: 449
It seems that's from the sessions table and says you have searched for the word "jem". ;)
If that's the only one (and you searched for parts, not hole words, meaning "jemmy" would also be found) there's nothings left in db.

Some files maybe left on /administrator/manifests/packages/ (this could cause problems).

-- BUT --

@Bluefox: I fear the install*.sql is wrong. After 'attachment_types' are 15 fields defined, but in INSERT line are 12 values only.
Maybe it's better to use the "INSERT IGNORE INTO tbl_name SET col_name=value, ..." syntax? Especially the settings table is toooo long to keep track of them.

Edit:
We could alternatively give all fields where possible a DEFAULT value in CREATE TABLE statement so we can limit the INSERT statement to - in best case - "INSERT INTO #__jem_settings SET id=1;" B)
Pessimists are optimists with experience!

Please Log in or Create an account to join the conversation.

Last edit: by Hoffi.

Change Date Format On Details Page 7 years 7 months ago #16926

@Bluefox: I fear the install*.sql is wrong. After 'attachment_types' are 15 fields defined, but in INSERT line are 12 values only.

not totally sure what you meant with that line.
(won't respond to PM)
==================================================================
running: pre-alpha JEM 4.x (custom version) + Joomla 4.0.0-beta7 + PHP 7.3

Please Log in or Create an account to join the conversation.

Change Date Format On Details Page 7 years 7 months ago #16928

  • Hoffi
  • Hoffi's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 2279
  • Thank you received: 449
On GitHub I looked into file JEM-3/admin/sql/install.mysql.utf8.sql taged with v3.0.6.
There I counted the number of fields listed in CREATE TABLE statement and compared with the number of values in INSERT statement. They must match but they don't.
So a fresh install of this version will cause a problem (same effect as Jojo found on my last change on that table for 2.1.2).
Pessimists are optimists with experience!

Please Log in or Create an account to join the conversation.

Change Date Format On Details Page 7 years 7 months ago #16931

hmm, have to take a look.

Did install the 3.0.6 package a couple of times now and didn't see a problem, also not after upgrade from 2.1.1->3
(won't respond to PM)
==================================================================
running: pre-alpha JEM 4.x (custom version) + Joomla 4.0.0-beta7 + PHP 7.3

Please Log in or Create an account to join the conversation.

Change Date Format On Details Page 7 years 7 months ago #16938

  • Hoffi
  • Hoffi's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 2279
  • Thank you received: 449
@Bluefox: Ok, you're right, it works. Had overlooked that the fields are listed on INSERT statement which are also three less than created.

But maybe my idea to give all except 'id' a default value and then simplify INSERT to SET id = 1 could ease future changes?
Pessimists are optimists with experience!

Please Log in or Create an account to join the conversation.

Change Date Format On Details Page 7 years 7 months ago #16939

  • MyWorld
  • MyWorld's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 73
  • Thank you received: 3
After removing the files from: administrator/manifests/packages/ it installed.

Yeah!! :silly: :woohoo:
The following user(s) said Thank You: jojo12

Please Log in or Create an account to join the conversation.

Time to create page: 0.550 seconds

Donate

If you find JEM useful and if you use it on your site, please consider a donation to the project.

Private Messages

You are not logged in.

Follow us......