| 07:43 |
posix^ |
"Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in .../t3lib/class.t3lib_db.php on line 796" What's the best way to deal with this? |
| 08:07 |
m4rtijn |
hey all |
| 08:17 |
posix^ |
m4rtijn: any idea how to deal with "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in .../t3lib/class.t3lib_db.php on line 796" |
| 08:18 |
m4rtijn |
hmm yeah |
| 08:18 |
m4rtijn |
did u just update typo3? |
| 08:23 |
posix^ |
I copied the dir and mysqlhotcopied the database |
| 08:23 |
posix^ |
to make another instance |
| 08:23 |
posix^ |
all I've changed is the db name in localconf.php |
| 08:26 |
m4rtijn |
is everything okay in the installtool? |
| 08:26 |
m4rtijn |
did u try: database analyzer -> "COMPARE" |
| 08:28 |
posix^ |
i'll do so |
| 12:33 |
Awillys |
anyone around? |
| 12:35 |
Awillys |
anyone who knows how to get tt_news article category title in TS using Getvar |
| 13:21 |
hever |
Hi. There is a standard content "text with image". But I need a content "text with FLV (Flash) Player" like "text with image" must I write such a content or is there a extension for this? |
| 13:31 |
kraftb |
greetings folks ! |
| 13:43 |
kraftb |
hey ... |
| 13:43 |
kraftb |
anyone ever got problems exporting/importing large sites/T3D files ? |
| 14:22 |
kraftb |
hi boonkerz ! |
| 14:23 |
Boonkerz |
hi |
| 14:23 |
Boonkerz |
i work on language in kb_shop |
| 14:25 |
kraftb |
cool.... |
| 14:25 |
kraftb |
i didn't find much time recently to work on the shop .... |
| 14:26 |
Boonkerz |
yes i know |
| 14:26 |
Boonkerz |
and i have many problems with 4.2 |
| 14:26 |
Boonkerz |
upload in files not work and so on |
| 14:38 |
otu |
Hi, |
| 14:44 |
otu |
I installed rss aggregator and didnt install the div extension. I got the error ¨TYPO3 Fatal Error: Extension key "div" was NOT loaded! (t3lib_extMgm::extPath)¨. Now i have tried to edit localconf.php removing the occurence of the rss extension as well as deleting the temp files. now all i get is a blank screen. anybody able to point me in the right direction? I have googled high and low and so far am not able to find a fix. and my website is |
| 14:44 |
otu |
down :( |
| 14:44 |
kraftb |
btw: anybody having problems importing/exporting large sites/t3d files ? |
| 15:08 |
Provito |
otu, cd to typo3conf and rm temp*. Ensure you have logged out the admin interface and try logging in again. |
| 15:16 |
otu |
provito, thanks for the reply. unfortunately i already did that and thats when I got the blank screen. |
| 15:17 |
otu |
Its driving me nuts. I cannot access anything, frontend backend nothing. |
| 15:22 |
Boonkerz |
kraftb yes i have memory limit and execution time problems |
| 15:22 |
Boonkerz |
:) |
| 15:22 |
kraftb |
boonkerz : http://lists.netfielders.de/pipermail/typo3-team-core/2008-July/017829.html |
| 15:23 |
kraftb |
tell me if it works ... |
| 15:23 |
kraftb |
you'll need to install the T3X as sysext ... |
| 15:23 |
kraftb |
I didn't modify the ext so it works as local ext ... |
| 15:23 |
kraftb |
probably it will work - but I didn't try it - and you would only need to set some vars in conf.php to let it work .... |
| 15:24 |
Boonkerz |
ok but i i need an h :) |
| 15:25 |
Boonkerz |
i trink coffee |
| 15:25 |
Boonkerz |
:D |
| 15:25 |
Boonkerz |
drink |
| 15:31 |
Awillys |
hi there |
| 15:31 |
Awillys |
tt_news: does anyone knows how to get the news category title fr |
| 15:32 |
Awillys |
from the news details page |
| 15:32 |
Awillys |
i.e. single view |
| 15:34 |
Awillys |
i tried: http://phpfi.com/333929 but it does not work |
| 15:48 |
XiXora |
i edited the ttnews template |
| 15:52 |
Awillys |
XiXora: ? |
| 15:52 |
Awillys |
anyway, another tt_news question: how do i get the category title to be shown in the news item url? |
| 16:13 |
the-fafa |
how different is typo3 compared to joomla? is typo3 better? |
| 16:16 |
chefan_ |
depends on the use case |
| 16:17 |
chefan_ |
typo3 has a learning necessity bordering on sillyness, but for complex sites you might need it |
| 16:18 |
chefan_ |
joomla is more like "setup, run, look good, miss a feature" |
| 16:21 |
posix^ |
I've recursively cp'd and mysqlhotcopied a typo3 install to another location for development, but the new install generates "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in .../t3lib/class.t3lib_db.php on line 796" a number of times. What's the best way to debug this? |
| 16:23 |
chefan |
i would suspect the new mysql lacks a matching db user with the proper rights |
| 16:25 |
chefan |
if you want to thoroughly debug that, the best starting point would be t3lib_db, find out the exact reason of the mysql error |
| 16:25 |
chefan |
that would help a lot in the search for what went wrong ;) |
| 16:33 |
posix^ |
chefan: the install tool tells me that it is connecting to the db successfully |
| 16:34 |
posix^ |
i.e. 'x is selected as database' |
| 16:34 |
posix^ |
connected successfully etc |
| 16:35 |
posix^ |
chefan: in this particularly outdated installation, that line refers to a function called "sql_fetch_assoc" |
| 16:38 |
posix^ |
function sql_fetch_assoc($res) { $this->debug_check_recordset($res); return mysql_fetch_assoc($res); } |
| 16:40 |
posix^ |
is there some kind of log I can enable that will tell me what is being passed to this function? |
| 16:41 |
chefan |
mysql-sided: |
| 16:42 |
chefan |
if mysql-assoc does not get a valid resource result, that usually means you had an error as a result in the database query before |
| 16:42 |
chefan |
if a query spits up an error, you won't get a result set |
| 16:43 |
chefan |
with a query that worked before, that would have it's reasons in lack of proper rights, errors in the connection or something like that |
| 16:44 |
chefan |
if it happens once, connection failures are a probable reason |
| 16:44 |
chefan |
if it fails systematically, password issues or stuff like that could be the reason |
| 16:44 |
chefan |
did you change the mysql version? |
| 16:45 |
chefan |
i don't remember when exactly but i remember there was some point where they switched the password hashes to longer, more secure hashes |
| 16:46 |
chefan |
that could be a problem for instance |
| 16:50 |
posix^ |
nope |
| 16:50 |
posix^ |
i didn't change versions |
| 16:50 |
posix^ |
its actually running on the same instance of apache and same instance of mysql as the working original |
| 16:52 |
posix^ |
basically, I 'cp -avR ./originaltypo3 ./clonetypo3' and then 'mysqlhotcopy originaldb clonedb'.. changed the db named in ./clonetypo3/typo3conf/localconf.php, and let it loose |
| 16:53 |
posix^ |
it does actually render the page, its just that I get about 20 of those mysql_fetch_assoc errors at the very top |
| 16:54 |
kraftb |
probably try to set "sqlDebug" to on in the install tool |
| 16:54 |
kraftb |
"on" i mean |
| 16:55 |
posix^ |
ah hah |
| 16:56 |
posix^ |
that explains things better |
| 16:56 |
posix^ |
a bunch of tables don't exist (despite the mysqlhotcopy?).. fe_sessions, cache_hash, cache_imageSizes |
| 17:04 |
posix^ |
can these be recreated easily? |
| 17:06 |
chefan |
you still have the old db? |
| 17:07 |
posix^ |
yup |
| 17:07 |
chefan |
you could dump them and reimport them |
| 17:07 |
chefan |
phpmyadmin makes that pretty easy |
| 17:08 |
chefan |
mysqldump creates sql statements from tables, so you can easily check out the dump too |
| 17:12 |
posix^ |
I read that you should ignore cache_* tables when dumping |
| 17:12 |
posix^ |
can I just drop cache_* on the new instance, and use the install tool to restore them? |
| 17:13 |
chefan |
oh, wait |
| 17:13 |
chefan |
there might be an easier way |
| 17:13 |
chefan |
you copied all the files, including the temporaries? |
| 17:14 |
chefan |
there could be your problem |
| 17:14 |
posix^ |
mysqlhotcopy'd everything, yea |
| 17:14 |
posix^ |
I just read on a forum you should ignore them though |
| 17:14 |
chefan |
all the tables you mentioned are runtime, sort of temporary |
| 17:14 |
posix^ |
so the install tool can recreate them if I drop cache_*? |
| 17:14 |
chefan |
and you probably copied the cache files too in typo3 |
| 17:15 |
chefan |
you could just remove those and rerun, that might help |
| 17:15 |
posix^ |
where are those? |
| 17:15 |
posix^ |
typo3conf/temp_CACHED_* ? |
| 17:17 |
chefan |
yup, i think that were the ones |
| 17:18 |
chefan |
they are just for caching, and while developing they occasionally get bothersome |
| 17:33 |
hever |
Hello, the extension rgimages doesn't work for me, what means it doesn't play my local FLV files.. There is no player the page is just empty if I use Text and Images/Videos... I think this is because I've not set up the JW Media Player. But I don't know how. Is there a extra extension for it ? |
| 17:36 |
posix^ |
chefan: ah, got it, working now.. thanks |
| 17:36 |
posix^ |
I had to rm a load of .frm's that were preventing the install tool from recreating cache_*, index_* |
| 17:48 |
kraftb |
hey .... |
| 17:48 |
kraftb |
making a copy of a site is really easy .... |
| 17:48 |
kraftb |
wait |
| 17:48 |
kraftb |
i'll post a "backup" script ... |
| 17:49 |
kraftb |
http://t3paste.org/42cuQF |
| 18:01 |
posix^ |
hm |
| 18:01 |
otu |
whenever i delete a pagecontent item, the frame doesnt finish loading and all thats displayed is a bunch of javascript. i tried setting the display errors to 1 and nothing has changed |
| 18:02 |
posix^ |
kraftb: I'm interested, but t3paste seems stuck |
| 18:02 |
posix^ |
oh nm |
| 18:26 |
kraftb |
stuck ... |
| 18:26 |
kraftb |
hmm ... can't resolve ip ? |
| 18:35 |
kraftb |
yhttp://rafb.net/p/5Kf8F725.html |
| 18:35 |
kraftb |
http://rafb.net/p/5Kf8F725.html |
| 18:54 |
chefan |
on the other hand it might be an idea to depersonalize passwords if you post scripts like that |
| 18:55 |
chefan |
and the script does about exactly what he did, a mysqldump. the script would not copy filesystem data, but just the database |
| 18:55 |
chefan |
which suits for some sites, but not for all |
| 19:01 |
snoy_ms_ |
I never used scripts for typo3 backup...its so easy like chefan say's...Just a small db dump without all cache and log tables and the four dynamic folders...thats it... |
| 19:01 |
hever |
Hello, the extension rgimages doesn't work for me, what means it doesn't play my local FLV files.. There is no player the page is just empty if I use Text and Images/Videos... I think this is because I've not set up the JW Media Player. But I don't know how. Is there a extra extension for it ? |
| 19:16 |
chefan |
heh, snoy_ms_ , all comes down to "never use scripts you couldn't have written yourself (and understand) ;) |
| 19:33 |
snoy_ms_ |
yep ;-) |
| 19:38 |
posix^ |
snoy_ms_: it'd be nice if there was a one-click backup/deploy though |
| 19:39 |
posix^ |
instead of having to come up with my own solution |
| 19:39 |
posix^ |
my situation is that I've inherited a typo3 install that is purely production |
| 19:40 |
posix^ |
so I'm urgently trying to roll out a clone for development, before the "developers" go and trash it |
| 19:41 |
posix^ |
I've got it going for the most part.. but the install tool, when doing a db compare, still has a load of 'alter table' queries it wants to make.. |
| 19:41 |
posix^ |
when I try running them, it sits for a few seconds, and then returns with what I assume is failure (no changes made) |
| 19:42 |
posix^ |
it seems to be failing on the statements trying to drop primary keys and recreate them |
| 19:43 |
posix^ |
and unfortunately I'm stuck at 4.1.2, since I have no dev instance to test an upgrade on.. |
| 19:46 |
swemark |
God evning |
| 19:46 |
swemark |
good* |
| 19:46 |
hever |
how can I look at the Typo Script of a content ? |
| 19:46 |
swemark |
ive been tryin to find a decent multi-file upload extension for a while now but i cant come up with any |
| 19:47 |
swemark |
any tips/ideas? |
| 19:47 |
swemark |
For frontend that is |
| 19:55 |
Phlogi |
file explorer maybe? But the flash upload there is kind of broken |
| 19:59 |
swemark |
i dont need flash |
| 20:00 |
swemark |
i just need multiple upload filds |
| 20:00 |
swemark |
fields* |
| 20:02 |
swemark |
and i just need the upload function |
| 20:02 |
swemark |
frankly i just want 5 upload-fields |
| 20:02 |
swemark |
quite stunning that typo3 doesnt incorporate an FE upload-function |
| 20:03 |
swemark |
feels like quite a basic thing |
| 21:25 |
Titi |
Hello there, can some help me, how to find some similar ext. or many ext. to make the user system and the news entries with some categories? Some users may has a permissions as moderator, editor with allow to login in some administration (maybe BE if it is secured) and they can by permissions edit some articles, adding them into some categories by permissions wich are allowed for him (there... |
| 21:25 |
Titi |
...should be about 6 type of users with some permissions), and so on. Can someone help me? I dont know if I can make the system for BE, and the clients should login here. Or make some FE administration and so on... can some help, talk about? Thank you |
| 22:21 |
hever |
Hello, the extension rgimages doesn't work for me, what means it doesn't play my local FLV files.. There is no player the page is just empty if I use Text and Images/Videos... I think this is because I've not set up the JW Media Player. But I don't know how. Is there a extra extension for it ? |
