xoops forums

Forum Index

Board index » All Posts (mjoel)


(1) 2 3 4 ... 24 »


mjoel

Quite a regular
Posted on: 11/25 0:38
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#1

Re: SQL error with Tag Module

11/25 0:38 Quote:

zyspec wrote:
@mjoel,

Sent you a PM to have you try something out to see if it works for you... let me know what you find.


zyspec..thank you very much..your fix works...

finally my tag module is now working again
Topic | Forum


mjoel

Quite a regular
Posted on: 11/17 23:22
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#2

Re: SQL error with Tag Module

11/17 23:22 thank you zyspec

i only use the tags only in my publisher module and another 4 clone publisher module..my current publisher is 1.07 final

XOOPS Version XOOPS 2.5.10
PHP Version 5.6.40
mySQL Version 5.7.28

System 2.14
Publisher 1.07 Final (4 clones)
Tag 2.34 RC2
MyLinks 3.11 RC4
xoopstube 1.06RC1
TDMDownloads 1.66 Beta 1
User Profile 1.9
PM 1.14 Final
XSitemap 1.52RC1
Sitemap 1.3
extgallery 1.13RC1
extcal 2.39 Final
xoopspoll 1.4 Beta 1
xoopsfaq 1.01
isearch 1.9
logcounterx 2.73
protector 3.61 Final
indexscan 2.03
xlanguage 3.11
defacer 1.12 Beta1
myMenu manager 1.3

currently the table xxx_tag_tag have 524 entries and the xxx tag_link have 1648 entries
Topic | Forum


mjoel

Quite a regular
Posted on: 11/15 0:11
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#3

Re: SQL error with Tag Module

11/15 0:11 thank you zyspec..but after i edited the block.php file i received blank page 500 error..
in debug message the sql error is now gone but i received blank page..

disable the block..the 500 error is gone

i double check the index page where my tags are not listed

i have the same sql error

0.000370 - SELECT DISTINCT(o.tag_id), o.tag_term, o.tag_status, SUM(l.tag_count) AS count, l.tag_modid FROM tag_tag AS o LEFT JOIN tag_stats AS l ON l.tag_id = o.tag_id GROUP BY o.tag_id ORDER BY count DESC LIMIT 0, 100
Error number: 1055
Error message: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxx.l.tag_modid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Topic | Forum


mjoel

Quite a regular
Posted on: 11/13 0:03
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#4

Re: SQL error with Tag Module

11/13 0:03 still have this error in the index page (no tags are listed) and top page where top tag block is activated

0.000475 - SELECT DISTINCT(o.tag_id), o.tag_term, o.tag_status, SUM(l.tag_count) AS count, l.tag_modid FROM tag_tag AS o LEFT JOIN tag_stats AS l ON l.tag_id = o.tag_id WHERE (o.tag_status = '0') GROUP BY o.tag_id ORDER BY count DESC LIMIT 0, 50
Error number: 1055
Error message: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxxxx.l.tag_modid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
Topic | Forum


mjoel

Quite a regular
Posted on: 11/7 6:22
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#5

SQL error with Tag Module

11/7 6:22 Hi..
Im using tag module 2.34RC2 downloaded from here https://github.com/XoopsModules25x/tag/
XOOPS Version XOOPS 2.5.10
PHP Version 5.6.40
mySQL Version 5.7.28

no tags are listed in index and blocks.. i received this sql error in debug message

SELECT DISTINCT(o.tag_id), o.tag_term, o.tag_status, SUM(l.tag_count) AS count, l.tag_modid FROM tag_tag AS o LEFT JOIN tag_stats AS l ON l.tag_id = o.tag_id GROUP BY o.tag_id ORDER BY count DESC LIMIT 0, 100

Error message: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxxx.l.tag_modid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Topic | Forum


mjoel

Quite a regular
Posted on: 10/30 4:36
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#6

Re: Trouble with Publisher 1.07

10/30 4:36 Quote:

mjoel wrote:

2. editing any current article does not have any problem but I'm having problem creating new article after submit i received the message "Sorry. It was not possible to update the article!"


i managed to solved this problem

1. Go to Publisher Preferences
2. enable the Show Development Tools Button
3. Click Migrate Tab . Click Show SQL > Do Migration > Write Schema
Topic | Forum


mjoel

Quite a regular
Posted on: 10/27 12:43
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#7

Re: wgGallery 1.10 ready for testing

10/27 12:43 Quote:

goffy wrote:
hi mjoel

i found the problem. can you please download current version from https://github.com/ggoffy/wggallery


the import from extgallery is now working..thank you..
Topic | Forum


mjoel

Quite a regular
Posted on: 10/27 12:39
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#8

Re: Trouble with Publisher 1.07

10/27 12:39 I tried adding at front end and back end ..i got the same weird error

Still tyring to figure out this problem
Topic | Forum


mjoel

Quite a regular
Posted on: 10/23 8:56
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#9

Re: Trouble with Publisher 1.07

10/23 8:56 i solved the problem number number 1

all the categories i set my username to be the moderator of the categories

i manually set it all back to 0 in phpmyadmin table

UPDATE `xx_publisher_categories` SET `moderator` = '0'


i don't have this problem in publisher 1.05

still trying to figure out problem #2
Topic | Forum


mjoel

Quite a regular
Posted on: 10/23 2:15
mjoel
mjoel (Show more)
Quite a regular
Posts: 283
Since: 2006/12/9
#10

Re: wgGallery 1.10 ready for testing

10/23 2:15 Hi

thanks for this module..great work so far

i downloaded the latest revision from github...i tried to import from my existing extgallery module ..im using eXtGallery 1.13 RC1

i have more than 10 albums and hundred of images but nothing is display

Resized Image

i received this error after submit

MySQL-Error: Unknown column 'ec.cat_text' in 'field list'
Topic | Forum



TopTop
(1) 2 3 4 ... 24 »



[Advanced Search]