[3.2][RC] Header Links

BigRed01 · Post by **BigRed01** » Tue Jul 03, 2018 6:12 pm

I tried updating yesterday form 3.2.0 rc2 to 3.2.1 rc1 and get this error. I'm on phpbb 3.2.2

SQL ERROR [ mysqli ]

Table 'gadget_forum.phpbb_headerlink' doesn't exist [1146]

SQL

INSERT INTO phpbb_headerlink (headerlink_id, headerlink_url, headerlink_name, headerlink_hover, headerlink_icon, headerlink_icon_colour, headerlink_icon_sw, headerlink_permission, headerlink_target, headerlink_button_colour, headerlink_text_colour, headerlink_text_shadow, headerlink_text_shadow_colour) VALUES ('1', 'https://hifikabin.me.uk', 'HiFi Kabin', 'Maybe the best forum in the world?', 'fa-music', '#FFFFFF', '1', '0', '1', '#1322D7', '#000000', '1', '#CBCBCB'), ('2', 'https://phpbb.com', 'phpBB', 'phpBB', 'fa-desktop', '#FFFFFF', '1', '1', '0', '#1A67FF', '#000000', '1', '#CBCBCB'), ('3', 'https://phpbb.hifikabin.me.uk', 'HiFi Kabins Extensions', 'Extensions', 'fa-code', '#FFFFFF', '0', '2', '0', '#1A67FF', '#000000', '1', '#CBCBCB'), ('4', 'https://phpbb.hifikabin.me.uk/app.php/seo', 'What about SEO?', 'All you need to know about SEO', 'fa-google', '#FFFFFF', '1', '3', '1', '#0C93D7', '#000000', '1', '#CBCBCB'), ('5', 'https://phpbb.hifikabin.me.uk/app.php/backup-stratagy', 'Backup Stratagy', 'Keeping your forum safe', 'fa-expeditedssl', '#FFFFFF', '1', '4', '0', '#FF0000', '#FFFFFF', '0', '#CBCBCB'), ('6', 'https://phpbb.hifikabin.me.uk/app.php/donation', 'Buy Me a Beer?', 'Would you like to buy me a beer?', 'fa-beer', '#000000', '1', '5', '0', '#FF7E20', '#FFFFFF', '0', '')

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 993
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 656
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 377
CALL: phpbb\db\driver\driver->sql_multi_insert()

FILE: [ROOT]/ext/hifikabin/headerlink/migrations/headerlink_schema.php
LINE: 54
CALL: phpbb\db\driver\factory->sql_multi_insert()

FILE: (not given by php)
LINE: (not given by php)
CALL: hifikabin\headerlink\migrations\headerlink_schema->insert_sample_data()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 714
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 661
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 436
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 190
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 209
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()

**My CDB Contributions** · Post by **HiFiKabin** » Tue Jul 03, 2018 7:10 pm

Did you disable AND delete data before updating?

BigRed01 · Post by **BigRed01** » Tue Jul 03, 2018 9:19 pm

HiFiKabin wrote: ↑
Tue Jul 03, 2018 7:10 pm
Did you disable AND delete data before updating?

Sorry did not delete data. I will give that a shot. thanks

**My CDB Contributions** · Post by **HiFiKabin** » Wed Jul 04, 2018 10:58 am

HeaderLinks v3.2.1 is totally different to v3.2.0 so it needs the data deleting before installing v3.2.1

Replace the 3.2.1 files, enable, disable, delete data and then proceed with 3.2.1

**My CDB Contributions** · Post by **HiFiKabin** » Mon Apr 08, 2019 10:46 am

3.2.1-RC2 now available

General tidy of code. The 'Link' button will not function on small devices that have JavaScript disabled and is hidden from view. The 'Under Header' option has been removed fro the main download in order to pass CDB validation. It is still available HERE as an addon to the main extension.

Update from previous version:

Download the latest release and unzip it.
Disable Header Link in the ACP
Delete headerlink folder from the server
Upload the folder hifikabin to root/ext/
Enable it in the ACP

yasser33311 · Post by **yasser33311** » Wed May 08, 2019 3:37 pm

after updating (phpbb&this ext)to latest version:

Code: Select all

SQL ERROR [ mysqli ]

Table 'shop.phpbb_headerlink' doesn't exist [1146]

SQL

SELECT * FROM phpbb_headerlink

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/hifikabin/headerlink/event/listener.php
LINE: 90
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: hifikabin\headerlink\event\listener->headerlink()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/includes/functions.php
LINE: 4261
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/index.php
LINE: 254
CALL: page_header()

**My CDB Contributions** · Post by **HiFiKabin** » Wed May 08, 2019 4:56 pm

I have updated (3.2.4>3.2.5>3.2.6>3.2.7) all of my test boards without error, so I don't know why this is happening for you but it appears that the database tables have not been created properly.

Disable the extension and re enable to see if that cures the problem, otherwise disable and delete data before re installing the extension. (obviously that would require re entering all of your links, so try the first suggestion first)

yasser33311 · Post by **yasser33311** » Wed May 08, 2019 5:33 pm

HiFiKabin wrote: ↑
Wed May 08, 2019 4:56 pm
I have updated (3.2.4>3.2.5>3.2.6>3.2.7) all of my test boards without error, so I don't know why this is happening for you but it appears that the database tables have not been created properly.

Disable the extension and re enable to see if that cures the problem, otherwise disable and delete data before re installing the extension. (obviously that would require re entering all of your links, so try the first suggestion first)

I also thought about this, But I do not want to lose data

i think this happen when i upgrade from old version of ext

**My CDB Contributions** · Post by **HiFiKabin** » Wed May 08, 2019 5:46 pm

Which headerlinks version did you update from?

yasser33311 · Post by **yasser33311** » Wed May 08, 2019 9:34 pm

HiFiKabin wrote: ↑
Wed May 08, 2019 5:46 pm
Which headerlinks version did you update from?

"version": "1.0.0-RC12",

i fix the problem by deleting data
thank you

**My CDB Contributions** · Post by **HiFiKabin** » Thu May 09, 2019 8:34 am

That explains it.

Important Note:
This version is written in a totally different way to those previously available and you MUST disable AND delete data before installing the current version. So remember to make a note of your existing button details first.

Galixte de EzCom · Post by **Galixte de EzCom** » Thu May 09, 2019 12:44 pm

Hi HiFiKabin,

is it possible to add the possibility to display some buttons to a specific group?

French translation updated.

Regards.

**My CDB Contributions** · Post by **HiFiKabin** » Thu May 09, 2019 4:21 pm

Not as the extension stands, Its certainly possible, but would require quite a rewrite of the code to make it work.

Something I have neither the time nor energy right now.

Thanks for the updated language pack.

yasser33311 · Post by **yasser33311** » Fri May 10, 2019 4:51 pm

HiFiKabin wrote: ↑
Thu May 09, 2019 8:34 am
That explains it.

Important Note:
This version is written in a totally different way to those previously available and you MUST disable AND delete data before installing the current version. So remember to make a note of your existing button details first.

The ext is not compatible with IDLaunch Fresh style
https://www.phpbb.com/customise/db/styl ... h_fresh_2/

the old version was compatible:

old version with style:
http://web.archive.org/web/201812281027 ... op4dz.com/
current version:
https://shop4dz.com/index.php?style=10

**My CDB Contributions** · Post by **HiFiKabin** » Fri May 10, 2019 5:44 pm

I haven't time right now but I should be able to make some adjustments to the extension to make it work with that style. Give me a day or two.

advertisements