3.2.x Extensions Database 3.2 / 3.3 ⇒ Quotes Collection

[Scanialady]

Thank you.

[martin]

Time is not on my side so enjoy this.
viewtopic.php?f=64&t=4014#p25023

[dmzx]

First post updated.

[SpIdErPiGgY]

PHP 8 gives an error when adding a quote:

Code: Select all

hpBB Debug] PHP Warning: in file [ROOT]/ext/dmzx/quotescollection/controller/main.php on line 271: Trying to access array offset on value of type bool

Is there a quick fix?

[martin]

Pls post that line of code the error is shown at.

[SpIdErPiGgY]

pls post that line of code the error is shown at.

This is line 271:

Code: Select all

						$last_post_date = $row['post_date'];

Whole thing:

Code: Select all

					// Check, if user added a quote within the last xx minutes
					if ($dm_qc_config['delay_set'] > 0)
					{
						$sql = 'SELECT post_date
							FROM ' . $this->dm_qc_table . '
							WHERE poster = ' . $this->user->data['user_id'] . '
							ORDER BY post_date DESC';
						$result = $this->db->sql_query_limit($sql, 1);
						$row = $this->db->sql_fetchrow($result);
						$last_post_date = $row['post_date'];
						$check_time = $last_post_date + (60 * $dm_qc_config['delay_set']);
						$this->db->sql_freeresult($result);

						if ($check_time > time())
						{
							// Show error
							$minutes = ($dm_qc_config['delay_set'] > 1) ? $this->user->lang['DM_QC_MINUTES'] : $this->user->lang['DM_QC_MINUTE'];
							$message = sprintf($this->user->lang['DM_QC_DELAY_ERROR'], $dm_qc_config['delay_set'], $minutes) . '<br /><br /><a href="' . $this->helper->route('dmzx_quotescollection_controller') . '">&laquo; ' . $this->user->lang['DM_QC_BACK_TO_MAIN'] . '</a>';
							trigger_error($message);
						}
					}

[martin]

Try this but your need to purge boards cache

Code: Select all

@$last_post_date = $row['post_date'];

[SpIdErPiGgY]

Try this but your need to purge boards cache

Code: Select all

@$last_post_date = $row['post_date'];

The error is gone on my founder account, but still shows with normal user account.

[max-ima]

Tested on 3.3.7 and works. Thanks

[max-ima]

.yml. chek says missing in tables.yml

Find

Code: Select all

parameters:
    dmzx.quotescollection.table.dm_qc: %core.table_prefix%dm_qc
    dmzx.quotescollection.table.dm_qc_config: %core.table_prefix%dm_qc_config

Replace with

Code: Select all

parameters:
    dmzx.quotescollection.table.dm_qc: '%core.table_prefix%dm_qc'
    dmzx.quotescollection.table.dm_qc_config: '%core.table_prefix%dm_qc_config'

[martin]

Yes as this is for 3.2 changes need to be made on all exts that you try to run on 3.3

[max-ima]

Yes as this is for 3.2 changes need to be made on all exts that you try to run on 3.3

Thanks

[max-ima]

Quotes Collection_1.0.7-Slovenian.zip