[TYPO3] sr_feuser_register: "Warning: mysql_fetch_assoc()"

[Dominik Schmich]

I couldn't find the repair, but i you meant the check some oft he checkboxen
which sould depend on the error and write them tot he database, thats what i
allready did.

But the sql debugging hint was nice. My problem is not because of the
sr_feuser_registr, ist related tot he static info tables. Here the error:

Caller:	t3lib_DB::exec_SELECTquery

ERROR:	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
'=''' at line 4

lastBuiltQuery:
SELECT static_country_zones.zn_name_de,static_country_zones.zn_name_local
FROM static_country_zones
WHERE static_country_zones.zn_code='DE' AND static_country_zones.=''

debug_backtrace:
require // tslib_fe->intincscript // tslib_cobj->user //
tslib_cobj->calluserfunction // call_user_method //
tx_srfeuserregister_pi1->main // tx_staticinfotables_pi1->init //
tx_staticinfotables_pi1->getstaticinfoname //
tx_staticinfotables_div::gettitlefromisocode // t3lib_db->exec_selectquery
// t3lib_db->debug

-----Ursprüngliche Nachricht-----
Von: typo3-english-bounces at lists.netfielders.de
[mailto:typo3-english-bounces at lists.netfielders.de] Im Auftrag von R. van
Twisk
Gesendet: Montag, 20. November 2006 14:58
An: TYPO3 English
Betreff: Re: [TYPO3] sr_feuser_register: "Warning: mysql_fetch_assoc()"

Dave did mean in the install tool
you can do a compare first, then a repair.

In the install tool there is also a option for SQL Debugging.
If you check it to on then you can clearly see what SQL gace
the error. Post it here so we can see what happens.


Now it's a bit guessing in the dark for us.


Ries

> Hi, 
> no problem dave...
> i just used phpmyadmin and did a repair over all tables and all were ok...
>
> -----Ursprüngliche Nachricht-----
> Von: typo3-english-bounces at lists.netfielders.de
> [mailto:typo3-english-bounces at lists.netfielders.de] Im Auftrag von dave
typo
> Gesendet: Montag, 20. November 2006 14:21
> An: TYPO3 English
> Betreff: Re: [TYPO3] sr_feuser_register: "Warning: mysql_fetch_assoc()"
>
> hey, this might sound obvious, but after comparing the tables, did you
find
> anything that needed repaired ? Because you have to repair them too ;)
>
> repair table [table_name];
>
> sorry if I sound like a n00b in offering help, but hey, sometimes crucial
> and easy steps like that are often left out.
>
> -Dave
>
> On 11/20/06, Dominik Schmich <ICEMANno1 at gmx.de> wrote:
>   
>> Hi,
>>
>> Typo3                           4.0.2
>> sr_feuser_register      2.5.2
>> static_info_tables      2.0.0
>> php                             4.4.0
>>
>> should be ok
>>
>> -----Ursprüngliche Nachricht-----
>> Von: typo3-english-bounces at lists.netfielders.de
>> [mailto:typo3-english-bounces at lists.netfielders.de] Im Auftrag von Dmitry
>> Dulepov
>> Gesendet: Montag, 20. November 2006 13:42
>> An: typo3-english at lists.netfielders.de
>> Betreff: Re: [TYPO3] sr_feuser_register: "Warning: mysql_fetch_assoc()"
>>
>> Hi!
>>
>> Dominik Schmich wrote:
>>     
>>> still the same error msg...
>>>       
>> Than check if your version of sr_feuser_register is compatible with
>> typo3 version.
>>
>> --
>> Dmitry Dulepov
>>
>> Web: http://typo3bloke.net/
>> Skype: callto:liels_bugs
>>     

-- 
Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/freelance-typo3.html
skype: callto://r.vantwisk


_______________________________________________
TYPO3-english mailing list
TYPO3-english at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english