Thanks for the bit of sql and your reply. I managed to do it with the Delete spam customers mod but thanks all the same.
Type: Posts; User: mcpisik
Thanks for the bit of sql and your reply. I managed to do it with the Delete spam customers mod but thanks all the same.
Great thanks. I used the last example there (And filled in the missing ); at the end, and edited to find the field with NULL that I needed.
I learned that I don't use the = "" , but instead use IS...
Thanks so much.
They all have first and last names, so if I wanted to look for Date of account creation instead (Only these spam ones have this field blank) could I change it to the following and...
Yes I have that installed and it worked on all spam customers that aren't 'empty'
But doesn't touch these sadly.
Hello! We have a few hundred empty spam accounts to delete.
All fields apart from name are empty, and cannot be deleted from admin.
So I need to delete them from the database 'customers' and...
Hello, after updating to 1.5.6c the module is still working.
Products all show correctly as before (1000s of them)
However, when viewing existing cross sells, the first item is not in the list,...
Yes, Block email status is set to true.
No error logs relating to this.
(Only some from russian hackers trying to do other stuff)
It's creating the users to block fine, using admin, but not...
Thanks for looking into it.
I've made the change, but can still create an account.
I'm using 1.5.4 and note your talk of the updates were for later versions.
I have yandex.com in my...
Thanks so much for creating this.
I've installed it on 1.54 and have it showing in admin.
I have blocked a spam username '[email protected]' and it shows in the banned_email.txt file now....
...The other module I added, then removed was Access Blocker.
No overwrites, but did have a database addition. Which I've un-installed.
(It was intended for 1.5.5+, not my 1.5.4)
I'm having a new problem, that I don't know if I've caused.
The only modules I've added this week are Delete Spam Customers and another ip blocking one that I've removed as was not working for...
Thanks for the idea.
I've installed it, but it's mostly for ip related blocking and no where to block by Company name or names in general.
If I could just block by Company name, I'd be sorted.
Thanks for the plugin.
Just wondering if there would be a way to block by the Company name field, in account creation?
Eg. My 1000+ fake accounts all use 'google' as the company name.
I'm hoping to block fake account creations, by blocking the Company Name field, if it equals 'google'
Every spam account created has google as the company for me.
Using 1.54 I'm not quite sure...
Thanks for the ideas. I'll get a test site going and try it out. Cheers.
Hi,
I have code in that shortens a customer name, to just first name and first initial of surname.
Works well.
I would like to, using phpmyadmin, change the existing customer_name to first name...
Thanks.
Any idea how they created an account with a previous customer number?
I just want to be sure they're not 'in' my system, rather than just making a fake account.
Hi,
So lately we've been getting lots of fake accounts.
The odd part is, some that are created today, have Customer Id's that are a few weeks old?
I may have deleted them back then, but how can...
Ah yes, thanks!
Always helpful thanks mc123
Hi,
In a product description, we have links such as:
<a href="http://oursite.com/hire-ladies-costumes/dazzling-silver-disco"> (Used in an image link)
Now that we are using SSL, I'm fixing those...
Ah perfect.
I have an upgrade in progress, so very good to know thanks :-)
Hi,
I'd like results from our search bar to include the ' symbol.
Eg. 1950's brings no results, but 1950s does.
One product was being found for 1950's:...
Thanks. It's not an upgrade. Just a move of a 1.5.4 to another server.
I'll see how the host gets on.
Think it may be just the dns that the host still seems to be playing with for some reason.
Hi,
Am just using the help page to move server.
Old site is still live.
Have uploaded 1.54 new install files and renamed 2 config files and permissions.
When entering my domain name followed by...
Hi, yes I'd tried finding a reference using dev tools, but came up empty.
Then I just realised the files may be all gone, but database may have something still.
Found it under Admin Menus table and...
Each time I access our admin, it throws up an error in the logs:
PHP Warning: constant(): Couldn't find constant BOX_HEADING_MINE in /home/..../admin/includes/functions/admin_access.php on line 854...
Thanks so much for replying.
I confirmed I have version 1.54
All files seem to have uploaded correctly.
I only seem to have a .htaccess file in the root of my hosting account.
(Not in my...
Hi,
I had to fully upload a backup of my website files to our host today.
The database was not touched and is still intact.
After doing so I only get the homepage of the site showing.
Clicking...
Hi, I have installed a mod (That has no support thread)
It is the keyword capturing mod.
So far it's up to 3mb in data.
I'd like to empty the data from 'addon_keyword_capturing' table.
And...
Old post, but may be useful to someone in future (As it is for me today)
To stop the firefox issue, I have uploaded images for each category. (As I always have done when I want an image)
But...
Thanks swguy for the advice.
I have a newer version of zen now, so they're no longer installed. So can't use the uninstall I guess.
Probably best to leave tables and config as is, as I'm no good...
Thank you for the mod.
1) With items that I no longer need, showing under New Database Tables, is there a safe way to delete those with phpmyadmin?
Example: customers_wishlist
2) With Missing...
Thanks Stevesh :)
I had just managed to slot the 'text-align: center;' part in somewhere, and found the images are not centered.
So while I'm looking if you happen to know what the center method...
Hi,
So I'd just like to change the name of each product, to be centered text.
(In product listing)
At the moment it is left aligned.
I searched and found a similar suggestion, to add in a...
Hi,
I was searching to fix a validation problem with my AddThis code.
Divavocals had suggested a fix on the AddThis site, as they hadn't bothered yet themselves.
I'd just like to know how to...
...in addition. I've just noted that CKeditor is not showing a broken link that's in my description.
Either in html view or source. It's just ommited.
If I switch to Tinymce or Plain Text, I can...
Perfection thanks GJH42
I've now changed it to a css file as suggested.
I'm not sure if I should bother changing the other few 1000 products?
But I'll at least make new items with this applied....
Hey Stevesh :)
Now that you've said that, I've viewed the page source and see the <!DOCTYPE....is added for me at the top.
Just seemed to remember seeing it in my actual HTML Source Editor years...
Hi,
So I started as a total beginner and am now trying to fix my wrongs.
Can someone tell me these easy things below? (I think I stripped out all the good html stuff in the beginning)
*...
Thanks for the message Digital. Your inbox is full so can't reply...
If you have any code please post it for me. I'll throw you a tip :)
We can't view the checkout process.
Nothing can be added to cart on your demo site....
In my log files I have the following myDEBUG files going on...
PHP Warning: Invalid argument supplied for foreach() in ..../includes/functions/extra_functions/reward_points_functions.php on line...
Awesome that you attempted the fix for tax in Reward Point module Hubert.
Would you know how to do it for standard rewards points? (Not tiered)
You seem to be the only one on the planet who has...
Did you ever work this out DigShadow? I'm trying to solve the same thing...
Brilliant :)
What a great day. I've been searching for this fix for so long.
Completely appreciate you taking the time to post this solution.
(Might be good to pack for the Plugins section)
Any idea how I...
Oh of course, thank you for that. I had originally meant that when writing previously, but as I wasn't viewing the phpmyadmin had forgotten the terms.
Appreciate the correct fix.
Thanks. How could I empty the emails it has archived, as it only deletes a month back? (quite large)
Hi, just checking if I can drop the email_archive table from database using phpmyadmin, in order to uninstall?
And then just delete all files supplied my mod?
Thanks!