Textpattern Forum

You are not logged in. Register | Login | Help

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 4,988
Website

Re: adi_matrix – Multi-article update tabs

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)


Yiannis
——————————
neme.org | neme-imca.org | hblack.net | LABS

Offline

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

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 918
Website

Re: adi_matrix – Multi-article update tabs

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!).

Offline

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 4,988
Website

Re: adi_matrix – Multi-article update tabs

Hi Adi,

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


Yiannis
——————————
neme.org | neme-imca.org | hblack.net | LABS

Offline

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

mrdale
Moderator
From: Walla Walla
Registered: 2004-11-19
Posts: 2,066
Website

Re: adi_matrix – Multi-article update tabs

(a most polite) bump… glz 11+?

Offline

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

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 918
Website

Re: adi_matrix – Multi-article update tabs

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.

Offline

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

Dimitri
Member
From: Johannesburg
Registered: 2010-10-31
Posts: 129

Re: adi_matrix – Multi-article update tabs

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


<txp:way_too_cool />

Offline

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

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 918
Website

Re: adi_matrix – Multi-article update tabs

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.

Offline

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

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 918
Website

Re: adi_matrix – Multi-article update tabs

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 SQLWHERE” 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.

Offline

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

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 418
Website

Re: adi_matrix – Multi-article update tabs

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)


jayrope

Offline

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

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 918
Website

Re: adi_matrix – Multi-article update tabs

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.

Offline

Board footer

Powered by FluxBB