I've got a strange issue, which after some googling, I've seen a few people mentioned, but I can't find a confirm solution. I'm aware it's a pretty old platform, but the rest of the site functions perfectly. If anyone can assist I'd be greatly appreciative.
If I try and use a large table of information on an information page (see below) on saving it deletes a lot of the information, and then the layout goes all over.
https://www.class58loco.group/test2824
However if I split the table into two smaller tables
https://www.class58loco.group/58001-025-status
&
https://www.class58loco.group/58026-050-status
So Im fairly certain it's not a coding issue with the table.
Could anyone assist please?
Many thanks
Andy
I have to make a few assumptions as it is not entirely clear what you have done or how or extensions / modifications manual edits.
Information table is mediumtext which refers to the size of the db field.
Copy and pasting code adds a lot of unnecessary code increasing the required size of the db field.
Using css correctly negates the need for the unnecessary code as well as effecting site speed which is relevant to SEO.
Splitting the table (which by this I assume you mean adding two tables) will add a little more code, - but not relevant in the grand scale of anything.
So what I believe is is happening is that the save function stops at the maximum field size which can be anywhere in the code .. ie it stop in the middle of code, a similar effect of thumbs where it stops and add ... this can be in the middle of a word.
You can change the field size in the db from mediumtext to longtext as a quick fix, but to need a longtext field for such a small amount of required code is probably going to be quite poor for SEO. I have seen much worse, but it is a long list of repetitive mistakes.
Regards,
Mona
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
The code is minified which it is probably not in the database and remembering that everything is encoded in the db so every < becomes < etc.
The current code is 63655 characters (62.45kb)
Clean code that does exactly the same 12928 characters (12.53kb) and a few lines of code in css
css
Code: Select all
table tr td{color:red}.thead td,table tr.ava td{color:#424242}.thead td,table tr td:first-child{font-weight:700}.thead td{padding-bottom:12px}
Code: Select all
<tr>
<td>58 047</td>
<td>Manton Colliery <br>(Apr '92)</td>
<td>-</td>
<td>-</td>
<td>Scrapped</td>
<td><b>Entered service:</b> Oct '86<b> • Withdrawn from service:</b> Sep '02<br>
<b>Exported:</b> Oct '04<b> • </b><b>Scrapped:</b> Monforte-del-Cid, Spain Dec '19</td>
</tr>
<tr class="ava">
<td>58 048</td>
<td>Coventry Colliery <br>(May '91)</td>
<td>Private Owner</td>
<td>Battlefield Line, <br>Shackerstone</td>
<td>Restoration</td>
<td><b>Entered service:</b> Nov '86<b> • Withdrawn from service:</b> Jan '00<br>
<p>Purchased from Crewe EMD in *** '16, the locomotive is currently undergoing restoration at the Battlefield Line, Shackerstone.</p>
</td>
</tr>
It is too long for a single post it is in two parts
Code: Select all
<table class="table table-bordered" style="text-align:center"><thead><tr class="thead"><td>TOPS No.</td><td>Name<br>(Date Named)</td><td>Current Owner</td><td>Location</td><td>Status</td><td>Notes</td></tr></thead><tbody><tr><td>58 001</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Dec '82 • <b>Withdrawn from service:</b> Oct '99<br><b>Exported:</b> Aug '09 • <b>Scrapped:</b> Alizay, France, May '23</td></tr><tr><td>58 002</td><td>Daw Mill Colliery<br>(Mar '88)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> May '83<b>• Withdrawn from service: </b>Nov '00<br><b>Scrapped:</b> EMR, Eastleigh, Dec '13</td></tr><tr><td>58 003</td><td>Markham Colliery<br>(Jul '88)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Jul '83<b>• Withdrawn from service: </b>Nov '99<br><b>Scrapped: </b>EMR Kingsbury, *** '10</td></tr><tr><td>58 004</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Sep '83<b>• Withdrawn from service: </b>Jan '02<br><b>Exported:</b> Oct '04<b>• Scapped: </b>Alizay, France, May '23</td></tr><tr><td>58 005</td><td>Ironbridge Power Station<br>(May '96)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Oct '83<b>• Withdrawn from service: </b>Oct '00<br><b>Exported:</b> Jun '09<b>• Scapped: </b>Alizay, France, *** '23</td></tr><tr><td>58 006</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Oct '83<b>• Withdrawn from service:</b> Jan '00<br><b>Exported:</b> Nov '09<b>• Scrapped:</b> Alizay, France, Jul '23</td></tr><tr><td>58 007</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Nov '83<b>• Withdrawn from service: </b>Jan '00<br><b>Exported:</b> Oct '04<b>• Scrapped: </b>Alizay, France, *** '23</td></tr><tr><td>58 008</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Dec '83<b>• Withdrawn from service:</b> Nov '99<br><b>Scrapped: </b>Eastleigh Works, *** '16</td></tr><tr><td>58 009</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Jan '84<b>• Withdrawn from service: </b>Jan '02<br><b>Exported:</b> Nov '04 • <b>Scrapped: </b>Alizay, France, *** '23</td></tr><tr><td>58 010</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Mar '84<b>• Withdrawn from service: </b>Dec '99<br><b>Exported:</b> Jun '05<b>• Scrapped: </b>Alizay, France, Jul '23</td></tr><tr><td>58 011</td><td>Worksop Depot<br>(Sep '93)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Mar '84<b>• Withdrawn from service: </b>Dec '99<br><b>Exported:</b> Jun '05<b>• Scrapped: </b>Alizay, France, Jul '23</td></tr><tr class="ava"><td>58 012</td><td>-</td><td>Private Owner</td><td>Battlefield Line,<br>Shackerstone</td><td>Stored</td><td><b>Entered service: </b>Mar '84<b>• Withdrawn from service: </b>Dec '99<br>Purchased from Ron Hull scarpyard in *** '16, and is currently awaiting restoration at the Battlefield Line, Shackerstone.</td></tr><tr><td>58 013</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Mar '84<b>• Withdrawn from service: </b>Apr '01<br><b>Exported:</b> Jun '01<b>• Scrapped: </b>Alizay, France, Jul '23</td></tr><tr><td>58 014</td><td>Didcot Power Station<br>(Jun '88)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Apr '84<b>• Withdrawn from service: </b>Nov '00<br><b>Scrapped: </b>EMR Kingsbury, *** '10</td></tr><tr><td>58 015</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Sep '84<b>• Withdrawn from service: </b>Oct '99<br><b>Exported:</b> Oct '04<b>•</b> <b>Scrapped:</b> Monforte-del-Cid, Spain Jan '20</td></tr><tr class="ava"><td>58 016</td><td>-</td><td>C58LG</td><td>UKRL, <br>Leicester</td><td>Restoration</td><td><b>Entered service:</b> Oct '84<b>• Withdrawn from service:</b> Aug '02<br>Purchased by the Class 58 Locomotive Group in Jun '10, and is currently undergoing restoration at UKRL Leicester.</td></tr><tr><td>58 017</td><td>Eastleigh Depot<br>(Sep '93)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Oct '84<b>• Withdrawn from service:</b> Apr '99<br><b>Scrapped:</b> EMR Kingsbury, Dec '13</td></tr><tr><td>58 018</td><td>High Marnham Power Station<br>(May '88)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Oct '84<b>• Withdrawn from service:</b> Dec '99<br><b>Exported:</b> Aug '05 • Scrapped: Alizay, France, *** '23</td></tr><tr><td>58 019</td><td>Shirebrook Colliery<br>(Oct '89)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Nov '84<b>• Withdrawn from service:</b> Apr '01<br><b>Scrapped: </b>EMR Kingsbury, *** '10</td></tr><tr><td>58 020</td><td>Doncaster Works BRE<br>(Nov '84)<br>Doncaster Works<br>(May '87)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Nov '84<b>• Withdrawn from service:</b> Sep '02<br><b>Exported:</b> May '04<b>• Scrapped:</b> Monforte-del-Cid, Spain Dec '19</td></tr><tr><td>58 021</td><td>Hither Green Depot<br> (Oct '85)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Dec '84<b>• Withdrawn from service: </b>Aug '02<br><b>Exported:</b> Jul '05 • Scrapped: Alizay, France, *** '23</td></tr><tr><td>58 022</td><td>-</td><td>Ivatt Diesel Recreation Society</td><td>Ecclesboure Valley Railway,<br>Worksworth</td><td>Doner<br>Locomotive</td><td><b>Entered service:</b> Dec '84<b>• Withdrawn from service: </b>Mar '02<br>Purchased from Crewe EMD in *** '16, . The chassis is being used in the re-creation of the LMS pioneer diesel 10000 locomotive project.</td></tr><tr class="ava"><td>58 023</td><td>Peterborough Depot<br>(Jun '95)</td><td>Private Owner</td><td>UKRL, <br>Leicester</td><td>Active</td><td><b>Entered service:</b> Dec '84<b>• Withdrawn from service:</b> Jul '02<br>Purchased from Ron Hull scarpyard in *** '16, and is currently active, undergoing final repairs at the UKRL site in Leicester.</td></tr><tr class="ava"><td>58 024</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Dec '84<b>• Withdrawn from service:</b> Sep '02<br><b>Exported:</b> May '04<b>• Scrapped:</b> Monforte-del-Cid, Spain Nov '19</td></tr><tr class="ava"><td>58 025</td><td>-</td><td>Continental Railways</td><td>Albacete, Spain</td><td>Stored</td><td><b>Entered service:</b> Jan '85<b>• Withdrawn from service: </b>Aug '02<br><b>Exported:</b> May '04</td></tr><tr><td>58 026</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Mar '85<b>• Withdrawn from service:</b> Jan '02<br><b>Exported:</b> Jun '09<b>• Scrapped:</b> Alizay, France, May '23</td></tr><tr class="ava"><td>58 027</td><td>-</td><td>Continental Railways</td><td>Albacete, Spain</td><td>Stored</td><td><b>Entered service: </b>Mar '85<b>• Withdrawn from service:</b> Sep '99<br><b>Exported:</b> May '04</td></tr><tr><td>58 028</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Mar '85<b>• Withdrawn from service:</b> Oct '99<br><b>Scrapped: </b>EMR Kingsbury, *** '10</td></tr><tr><td>58 029</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Mar '85<b>• Withdrawn from service: </b>Jun '02<br><b>Exported:</b> May '04<b>• Scrapped:</b> Monforte-del-Cid, Spain Jan '20</td></tr><tr><td>58 030</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Oct '83<b>• Withdrawn from service: </b>Oct '00<br><b>Exported:</b> Jun '09<b>• Scapped: </b>Alizay, France, *** '23</td></tr><tr><td>58 031</td><td>Cabellero Ferroviario<br>(Jun '08)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Sep '85<b>• Withdrawn from service:</b> Apr '02<br><b>Exported:</b> May '04<b>• Scrapped:</b> Monforte-del-Cid, Spain Feb '20</td></tr><tr><td>58 032</td><td>Thorsby Colliery<br>(Oct '95)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Sep '85<b>• Withdrawn from service:</b> Jan '00<br><b>Exported:</b> Oct '04<b>• Scrapped:</b> Alizay, France, May '23</td></tr><tr><td>58 033</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Sep '85<b>• Withdrawn from service: </b>Aug '02<br><b>Exported:</b> Oct '04<b>• Scrapped:</b> Alizay, France, Mar '23</td></tr><tr><td>58 034</td><td>Bassetlaw<br>(Dec '85)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Nov '85<b>• Withdrawn from service:</b> Aug '99<br><b>Exported:</b> Oct '04<b>• Scrapped:</b> Alizay, France, May '23</td></tr><tr><td>58 035</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Jan '86<b>• Withdrawn from service:</b> Jun '99<br><b>Exported:</b> Oct '04<b>• Scrapped: </b>Alizay, France, *** '23</td></tr><tr><td>58 036</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Feb '86<b>• Withdrawn from service:</b> Mar '00<br><b>Exported:</b> *** '**<b>• Scrapped:</b> Alizay, France, *** '23</td></tr><tr><td>58 037</td><td>Worksop Depot<br>(Jun '00)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Feb '86<b>• Withdrawn from service:</b> Apr '02<br><b>Scrapped:</b> EMR, Eastleigh, Dec '13</td></tr><tr><td>58 038</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Feb '86<b>• Withdrawn from service:</b> Dec '99<br><b>Exported:</b> May '05<b>• Scrapped:</b> Alizay, France, May '23</td></tr><tr><td>58 039</td><td>Rugeley Power Station<br>(Sep '86)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Mar '86<b>• Withdrawn from service:</b> Dec '99<br><b>Exported:</b> Jun '03<b>• Scrapped: </b>Alizay, France, *** '23</td></tr><tr><td>58 040</td><td>Cottam Power Station<br>(Sep '86)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Mar '86<b>• Withdrawn from service:</b> Dec '99<br><b>Exported:</b> Nov '04<b>• Scrapped: </b>Alizay, France, Jul '23</td></tr><tr class="ava"><td>58 041</td><td>Ratcliffe Power Station<br>(Sep '86)</td><td>Continental Railways</td><td>Albacete, Spain</td><td>Stored</td><td><b>Entered service:</b> Mar '86<b>• Withdrawn from service:</b> Jul '02<br><b>Exported:</b> Apr '03</td></tr><tr><td>58 042</td><td>Ironbridge Power Station<br>(Sep '86)<br>Petrolea<br>(Feb '96)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> May '86<b>• Withdrawn from service:</b> Apr '02<br><b>Exported:</b> Aug '09<b>• Scrapped: </b>Alizay, France, May '23</td></tr>
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Code: Select all
<tr><td>58 043</td><td>Knottingley<br>(Apr '93)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Jul '86<b>• Withdrawn from service:</b> Aug '02<br><b>Exported:</b> Apr '03<b>• Scrapped:</b> Monforte-del-Cid, Spain Jan '20</td></tr><tr><td>58 044</td><td>Oxcroft Opencast<br>(May '92)</td><td>ETF</td><td>Woippy Yard,<br>Metz,<br>France</td><td>Stored</td><td><p><b>Entered service:</b> Aug '86 • Withdrawn from service: Jul '99 </p><p><b>Exported:</b> Oct '03</p><p>Left in Woippy Yard, after issues with the wheel sets were found while the loco was being returned to Alizay in 2013.</p></td></tr><tr><td>58 045</td><td>-</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Sep '86<b>• Withdrawn from service:</b> Aug '02<br><b>Scrapped: </b>AEMR Kingsbury *** '10<br>Breifly purchased by the Class 58 Locomotive Group, to obtain parts for the restoration of '016 including the power unit.</td></tr><tr><td>58 046</td><td><p>Thoresby Colliery </p><p>(June '91)</p><p>Ashfordby Mine </p><p>(Sep '95)</p></td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service: </b>Oct '86<b>• Withdrawn from service:</b> Jan '00<br><b>Exported:</b> Sep '04<b>• Scrapped:</b> Alizay, France, *** '23</td></tr><tr><td>58 047</td><td>Manton Colliery<br>(Apr '92)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Oct '86<b>• Withdrawn from service:</b> Sep '02<br><b>Exported:</b> Oct '04<b>• Scrapped:</b> Monforte-del-Cid, Spain Dec '19</td></tr>
<tr class="ava"><td>58 048</td><td>Coventry Colliery<br>(May '91)</td><td>Private Owner</td><td>Battlefield Line,<br>Shackerstone</td><td>Restoration</td><td><p><b>Entered service:</b> Nov '86<b>• Withdrawn from service:</b> Jan '00</p><p>Purchased from Crewe EMD in *** '16, the locomotive is currently undergoing restoration at the Battlefield Line, Shackerstone.<br></p></td></tr><tr><td>58 049</td><td>Littleton Colliery<br>(Mar '87)</td><td>-</td><td>-</td><td>Scrapped</td><td><b>Entered service:</b> Dec '86<b>• Withdrawn from service:</b> May '02<br><b>Exported:</b> Nov '04<b>• Scrapped:</b> Alizay, France, Jul '23</td></tr><tr class="ava"><td>58 050</td><td>Toton Traction Depot<br>(May '87)</td><td>Continental Railways</td><td>Albacete, Spain</td><td>Stored</td><td><p><b>Entered service:</b> Mar '87<b>• Withdrawn from service:</b> Aug '02<br><b>Exported:</b> Sep '08</p><p><b>This loco has been earmarked for the national collection by the Railway Heritage Trust.</b></p></td></tr></tbody></table>
Attachments
WITHOUT UNNECESSARY CODE - with-unnecessary-code-removed.png (656.55 KiB) Viewed 685 times
ORIGINAL - original.png (2.01 MiB) Viewed 685 times
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Many thanks for your detailed reply.
I essentially started using the clean table option with the information page, but as that only let me have a maximum of 10x10 I then started copying/pasting the code to achieve the extra rows required.
Sorry, when I said I'd split the table into two, I'd done 58001-25 on one information page, and 58026-50 on another information page.
I did however last night start trying to delete some of the code, but I nowhere near got it as clean as you have. Many thanks for your help there, it's greatly appreciated.
In the end I did actually manage to get the desired function by copy/pasting the code directly, into the database field in phpmyadmin. However, not ideal it gave me what I needed quickly. One page, with the whole table on it. However it was messy, However, when it comes to updates that maybe an issue.
https://www.class58loco.group/class-58-status
I think I'll continue what you started if that's ok with you?
Many thank for your assistance.
Andy
Clean code is so much easier to work with anyway.
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
In that case the problem was probably the php.ini settings of your post_max_size and max_input_vars.eisteddfod_37 wrote: ↑Thu Aug 29, 2024 6:13 pmIn the end I did actually manage to get the desired function by copy/pasting the code directly, into the database field in phpmyadmin.
And as above cleaning the code with Ctrl + Shift + V when you paste, or with one of the many online HTML code cleaners would be a very good idea.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
https://www.atlassian.com/data/database ... data-types
Encoded it is at least 122,291 characters
I would still
1. Fix the code first
2. If there is still a problem increase the TEXT field to MEDIUMTEXT and then
3. see if you can increase the php.ini settings
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Thanks Paul,paulfeakins wrote: ↑Thu Aug 29, 2024 7:33 pmIn that case the problem was probably the php.ini settings of your post_max_size and max_input_vars.eisteddfod_37 wrote: ↑Thu Aug 29, 2024 6:13 pmIn the end I did actually manage to get the desired function by copy/pasting the code directly, into the database field in phpmyadmin.
And as above cleaning the code with Ctrl + Shift + V when you paste, or with one of the many online HTML code cleaners would be a very good idea.
I did have a look in the php.ini file, as it was recommended in another post however I don't have an option for "post_max_size"
Code: Select all
magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 64M;
max_execution_time = 36000;
upload_max_filesize = 999M;
safe_mode = Off;
mysql.connect_timeout = 20;
session.auto_start = Off;
session.use_only_cookies = On;
session.use_cookies = On;
session.use_trans_sid = Off;
session.cookie_httponly = On;
session.gc_maxlifetime = 3600;
allow_url_fopen = on;
;display_errors = 1;
;error_reporting = E_ALL;
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
It could be this also.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Users browsing this forum: No registered users and 39 guests