xoops forums

Forum Index


Board index » All Posts (mjoel)




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

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


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

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


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

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_termo.tag_statusSUM(l.tag_count) AS countl.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 0100
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


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

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_termo.tag_statusSUM(l.tag_count) AS countl.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 050
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]


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

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_termo.tag_statusSUM(l.tag_count) AS countl.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 0100

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


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

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


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

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


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

I tried adding at front end and back end ..i got the same weird error

Still tyring to figure out this problem


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

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_categoriesSET `moderator` = '0'


i don't have this problem in publisher 1.05

still trying to figure out problem #2


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

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'



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