11
trabis
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/16 13:52

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Hum, I don't see any update or insert query. You need to stop the redirecting page by clicking on the red cross of your browser, then report me back the debug info.

12
wcrwcr
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/19 19:14

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


Hi Trabis

thanks for your interest and sorry about my delay on feeding you back

SELECT FROM xoops_config WHERE (conf_modid '0' AND conf_catid '1'ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id 
'14d878a2b4bd74c6901ad4d100721640'
SELECT FROM xoops_users WHERE uid=1
SELECT 
FROM xoops_modules WHERE dirname 'soapbox'
SELECT FROM xoops_config WHERE (conf_modid '12'ORDER BY conf_order ASC
UPDATE xoops_sbarticles SET columnID 
'1'headline '10 Dicas para Preparar sua Equipe de Vendas'lead 'Nossa percepção não nos dá, necessariamente, o conhecimento. No entanto, realidade pode ser aproximada à percepção! Percebemos, mas podemos não conhecer. 'bodytext 'Nossa percepção não nos dá, necessariamente, o conhecimento. No entanto, realidade pode ser aproximada à percepção! Percebemos, mas podemos não conhecer. 'teaser 'Nossa percepção não nos dá, necessariamente, o conhecimento. No entanto, realidade pode ser aproxim...'weight '1'html '1'smiley '1'xcodes '1'breaks '1'block '1'artimage ''votes '0'rating '0'comments '1'offline '0'datesub '1258657699' WHERE articleID '67'
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset 'default' AND tpl_file 'system_redirect.html'ORDER BY tpl_refid


that´s what i get stoping the redirect (i´ve just cutted some looooong article text, ok?

BTW> i could not found what you´ve told me "xxxx has no default value"".

thanks

13
trabis
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/19 20:11

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Are you using latest version of soapbox?
http://dev.xoops.org/modules/xfmod/project/showfiles.php?group_id=1020

14
wcrwcr
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/24 18:38

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


Hi

No, I was using an older one
I´ve just updated to the one you´ve pointed but now, I have:

SELECT FROM xoops_config WHERE (conf_modid '0' AND conf_catid '1'ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id 
'f62640a4fe4e7d83f0c25fb37532f495'
SELECT FROM xoops_users WHERE uid=1
SELECT 
FROM xoops_modules WHERE dirname 'soapbox'
SELECT FROM xoops_config WHERE (conf_modid '12'ORDER BY conf_order ASC
SELECT COUNT
(*) FROM xoops_sbcolumns
SELECT 
FROM xoops_sbcolumns WHERE columnID '13'
SELECT FROM xoops_sbarticles WHERE articleID '67'
SELECT FROM xoops_config WHERE (conf_modid '0' AND conf_catid '4'ORDER BY conf_order ASC


plus a: UPDATE xoops_sbarticles SET columnID = 13 , headline = '10 Dicas para Preparar sua Equipe de Vendas'

And a warning at the redirect saying: "Sorry it was not possible to update this article"

wierd isn´t it?

15
wcrwcr
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/24 18:50

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


some news:

UPDATE xoops_sbarticles SET columnID 13 headline '10 Dicas para Preparar sua Equipe de Vendas' lead 'Nossa percepção não nos dá, necessariamente, o conhecimento. No entanto, realidade pode ser aproximada à percepção! Percebemos, mas podemos não conhecer.' bodytext 'Nossa percepção não nos dá, necessariamente, o conhecimento. No entanto, realidade pode ser aproximada à percepção! Percebemos, mas ..............

etc etc etc (article content)...
O DNA do Vendedor Campeão' 
teaser 'Nossa percepção não nos dá, necessariamente, o conhecimento. No entanto, realidade pode ser aproxim...' uid submit datesub 1258657699 counter 14 weight html smiley xcodes breaks block artimage 'blank.png' votes rating 0.000000 commentable offline notifypub 0 WHERE articleID 67
Error number
1054
Error message
Unknown column 'commentable' in 'field list'


the redirect warning reamains the same

16
wcrwcr
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/24 19:00

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


And so I´ve tried to creat a fresh article...

at the admin side, in the center i have almost a blank page except for an "Array()" printed on the top center.

queries:
SELECT FROM xoops_config WHERE (conf_modid '0' AND conf_catid '1'ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id 
'f62640a4fe4e7d83f0c25fb37532f495'
SELECT FROM xoops_users WHERE uid=1
SELECT 
FROM xoops_modules WHERE dirname 'soapbox'
SELECT FROM xoops_config WHERE (conf_modid '12'ORDER BY conf_order ASC
SELECT COUNT
(*) FROM xoops_sbcolumns
SELECT 
FROM xoops_sbcolumns WHERE columnID '13'
SELECT FROM xoops_config WHERE (conf_modid '0' AND conf_catid '4'ORDER BY conf_order ASC
INSERT INTO xoops_sbarticles 
(articleIDcolumnIDheadlineleadbodytextteaseruidsubmitdatesubcounterweighthtmlsmileyxcodesbreaksblockartimagevotesratingcommentableofflinenotifypubVALUES (013'Olá''Olá olá''Olá olá Olá olá Olá olá Olá olá Olá olá Olá olá Olá olá Olá oláOlá oláOlá oláOlá olá Olá olá Olá olá''Olá olá Olá olá Olá olá Olá olá Olá olá Olá olá Olá olá Olá oláOlá oláOlá oláOlá olá Olá olá Olá...'1012590889860111111'blank.png'00.00000000)
Error number1054
Error message
Unknown column 'commentable' in 'field list'
SELECT FROM xoops_group_permission WHERE (gperm_name 'module_admin' AND gperm_modid '1' AND (gperm_groupid '1' OR gperm_groupid '2'))



17
ghia
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/24 21:24

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Quote:
Error message: Unknown column 'commentable' in 'field list'
You are missing a column in your xoops_sbarticles table.
Did you update the module after upgrading?
It is possible that this column was introduced in the newer version and somehow was not etablished in your database due to missing or failed upgrade actions.

18
wcrwcr
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/24 22:34

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


yep Ghia

update the module, check and repair DB and updated to XOOPS 20182 at least

thanks anyway

19
ghia
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/25 1:03

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Did you check with phpMyAdmin, that you have field 'commentable' in your xoops_sbarticles table?

20
wcrwcr
Re: Soapbox:Fatal error: Using $this when not in object context in...
  • 2009/11/25 13:47

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


Quote:
Did you check with phpMyAdmin, that you have field 'commentable' in your xoops_sbarticles table?


No I don´t have It

And looking a bit forward in the "sbcolumns" table I´ve found an error:

Following indexes seems to be identical and one of them must be removed "PRIMARY, columnID"

I´ll do te suggested action and come back with fresh news.

If that fails as well i´ll unnisntall and reinstal the module to check if that version works with php 5 and XOOPS 20182.

Thank you

Login

Who's Online

143 user(s) are online (86 user(s) are browsing Support Forums)


Members: 0


Guests: 143


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits