adi_matrix – Multi-article update tabs

mrdale · 2011-06-25 17:25:27

Thanks for this plugin… I need glz 11+ support too.

Happy to provide you with a guinea-pig install.

gomedia · 2011-06-26 19:44:23

mrdale wrote:

Happy to provide you with a guinea-pig install.

Yes please … currently on holiday but normal service will be resumed in late July.

colak · 2011-07-05 18:28:12

Hi Adi:)

After installing I get this in extensions>adi_matrix

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Field = 'article_image'' at line 1 SHOW FIELDS FROM adi_matrix WHERE Field = 'article_image' in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 89

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 295

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 297

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Field = 'criteria_timestamp'' at line 1 SHOW FIELDS FROM adi_matrix WHERE Field = 'criteria_timestamp' in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 89

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 295

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 297

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Field = 'criteria_expiry'' at line 1 SHOW FIELDS FROM adi_matrix WHERE Field = 'criteria_expiry' in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 89

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 295

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 297

Also underneath it says: adi_matrix: Upgrade required

Using txp4.4.1 (on MySQL: 4.1.18) Any ideas of what I might have done wrong?… or is it my db version?

Last edited by colak (2011-07-05 18:30:11)

gomedia · 2011-07-06 07:31:45

Hi Yiannis,

Looks like adi_matrix is accessing the database using something that MySQL 4.1 doesn’t like.

I’ll look into it after my hols (end of July – sorry!).

colak · 2011-07-06 07:33:13

Hi Adi,

No problem. If you want access to my site, let me know:)

mrdale · 2011-08-04 15:20:51

(a most polite) bump… glz 11+?

gomedia · 2011-08-04 21:40:03

mrdale wrote:

(a most polite) bump… glz 11+?

Yep, I know. Part of me is still having a pub lunch, somewhere in the east of England. I did have adi_matrix open in an editor yesterday – but then my mind drifted off … “Time gentlemen please” … I’ll get cracking this weekend.

Dimitri · 2011-08-07 18:59:38

Plugin doesnt work in 4.4.1… failed to write to database correctly. No fields created in new table

gomedia · 2011-08-07 22:04:05

Dimitri wrote:

Plugin doesnt work in 4.4.1… failed to write to database correctly. No fields created in new table

It’s working fine for me. If you’re refering to colak’s issue then I’ll be looking at that after glz_custom_fields integration is done.

gomedia · 2011-08-09 23:07:42

colak wrote:

After installing I get this in extensions>adi_matrix

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE Field = ‘article_image’‘ at line 1 SHOW FIELDS FROM adi_matrix WHERE Field = ‘article_image’ in /users/home/ccc/web/public/textpattern/lib/txplib_db.php on line 89

Just for the record, it’s caused by adi_matrix using an SQL “WHERE” clause that’s not available in MySQL 4.1. There’s an alternative & I’ve advised colak to edit the plugin as a temporary measure to change all instances of:

WHERE Field =

to:

LIKE

Fortunately this is forward compatible with later versions of MySQL & I’ll include it in the next release of adi_matrix.

jayrope · 2011-08-12 12:16:16

Thanx for the mySQL 4.1 fix. Worked :)

Here’s an attempt on a textpack in German (Didn’t translate “Nothing to do” as i do not know, when this message would appear. Normally this translates to “Nichts zu tun”, but if this is to state, that there’s no Matrix to work on, then this might want to result in telling the user to create a matrix first, like “Keine Matrix vorhanden” for “no matrix existing” or “Bitte legen Sie eine Matrix an” for “Please create a matrix first”..)

adi_article_data => Artikeldaten
adi_textpack_fail => Textpack-Installation fehlgeschlagen
adi_textpack_feedback => Textpack-Feedback
adi_textpack_online => Textpack ist auch online verfügbar
adi_user => Benutzer
adi_any_category => Jede Kategorie
adi_article_highlighting => Artikeltitel hervorheben
adi_article_limit => Maximale Artikelanzahl
adi_article_selection => Artikelauswahl
adi_article_tooltips => Artikeltitel Tooltips
adi_article_update_fail => Artikelaktualisierung fehlgeschlagen
adi_articles_saved => Artikel gesichert
adi_display_article_id => Artikel-ID anzeigen
adi_expiry => Ablaufdatum
adi_has_expiry => Hat Ablaufdatum
adi_install_fail => Installation nicht möglich
adi_installed => Installiert
adi_logged_in_user => Angemeldeter Benutzer
adi_matrix => Matrix
adi_matrix_delete_fail => Löschen der Matrix fehlgeschlagen
adi_matrix_deleted => Matrix gelöscht
adi_matrix_name => Name der Matrix
adi_matrix_update_fail => Aktualisierung der Matrix-Einstellungen fehlgeschlagen
adi_matrix_updated => Matrix-Einstellungen aktualisiert
adi_no_category => Keine Kategorie
adi_no_expiry => Kein Ablaufdatum
adi_not_installed => Nicht installiert
adi_nothing_to_do => Nothing to do
adi_one_category => Eine Kategorie
adi_pref_update_fail => Aktualisierung der Voreinstellungen fehlgeschlagen
adi_two_categories => Zwei Kategorien
adi_uninstall => Deinstallieren
adi_uninstall_fail => Deinstallation fehlgeschlagen
adi_uninstalled => Deinstalliert
adi_update_matrix => Matrix-Einstellungen aktualisieren
adi_update_prefs => Voreinstellungen aktualisieren
adi_upgrade_fail => Upgrade nicht möglich
adi_upgrade_required => Upgrade benötigt
adi_upgraded => Upgrade erfolgreich

Last edited by jayrope (2011-08-12 12:19:27)

gomedia · 2011-08-12 23:13:14

jayrope wrote:

Thanx for the mySQL 4.1 fix. Worked :)

Phew!

Here’s an attempt on a textpack in German (Didn’t translate “Nothing to do” as i do not know, when this message would appear.

Thanks for the translations. I’ve uploaded them & they’re ready to go. “Nothing to do” actually means “No articles to update”. Because adi_matrix only updates individual articles that have actually had something changed, the message appears if the user hits Save without making data modifications.

Textpattern CMS

Textpattern CMS support forum

#49 2011-06-25 17:25:27

Re: adi_matrix – Multi-article update tabs

#50 2011-06-26 19:44:23

Re: adi_matrix – Multi-article update tabs

#51 2011-07-05 18:28:12

Re: adi_matrix – Multi-article update tabs

#52 2011-07-06 07:31:45

Re: adi_matrix – Multi-article update tabs

#53 2011-07-06 07:33:13

Re: adi_matrix – Multi-article update tabs

#54 2011-08-04 15:20:51

Re: adi_matrix – Multi-article update tabs

#55 2011-08-04 21:40:03

Re: adi_matrix – Multi-article update tabs

#56 2011-08-07 18:59:38

Re: adi_matrix – Multi-article update tabs

#57 2011-08-07 22:04:05

Re: adi_matrix – Multi-article update tabs

#58 2011-08-09 23:07:42

Re: adi_matrix – Multi-article update tabs

#59 2011-08-12 12:16:16

Re: adi_matrix – Multi-article update tabs

#60 2011-08-12 23:13:14

Re: adi_matrix – Multi-article update tabs

Board footer