EllisLab Community Forums

1and1 restored website not working

2012-11-23T20:20:47-05:00

Hi Guys,
This is a weird one. I built an EE site about 2 years ago and everything was fine until the client accidentally deleted the account in their 1and1.co.uk control panel.
1and1 have restored the account but it’s not working properly.

The site displays the home page no matter what the url says. And there are errors appearing in the control panel.

Strict Standards: Non-static method Utilities::clear_cache_form() should not be called statically, assuming $this from incompatible context in “serverpath” on line 402

Any pointers would be greatly appreciated.
Thanks
Patricia

Spammers adding themselves as members

2012-11-09T16:38:08-05:00

We have a website that offers paid membership for premium content. Somehow, there are bots/spammers who are adding themselves as new members through EE. They’re not submitting a form through the website, they’re coming directly into EE which nobody has access to except authorized staff members, so it’s a little disconcerting.

We think we’ve locked down EE as much as possible in regards to membership. Accounts need to be approved by staff before they are able to use the website. Accounts also are set to pending status before they are approved. We’ve also added the IP address to the Blacklist within EE.

Oh and we’re running EE 1.7.3, which I believe is the latest version.

Is there anything else we can do to block these requests from being processed?

thanks

geof

strange error when installing blacklist module

2012-11-23T12:13:40-05:00

One of my clients still runs ExpressionEngine 1.6.7 Build: 20090320

He has recently a lot of spam so we want to activate the blacklist module.
The activation of the module went OK, but when adressing the View Blacklist
I get this error
error
Blacklist database table does not exist

On another build 1.6.8 this works.

How can I fix this, please? Should I update to 1.6.8?

Thanks!!

Problems moving EE 1.67 to new server

2012-10-04T16:46:14-05:00

hi, i have a very similar problem. i was trying to move my EE site from one server to another. It’s running EE 1.67. I got the theme and template to load, but none of the images that got uploaded for a photo slider and none of the content load. Plus, i can’t log in to the control panel. It took the username and password without throwing an error, but it gives me a blank page.
Please HELP!

additional info: after i get a blank page for my admin log in, i get this error from my homepage:
“MySQL ERROR:

Error Number: 1064

Description: 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 ‘ORDER BY `title` ASC’ at line 1

Query: SELECT * FROM ORDER BY `title` ASC”

Slow Post/Processing - Register Form

2012-10-11T13:05:45-05:00

Greetings.

I have the following code being used as a registration form. All other pages on the site load quickly, except for this one. The form posts, but takes minutes to load. Once it loads, the registration is completed with no apparent issues (the member is created properly, the activation email is sent, the page redirects as defined by the RET input.) Nothings is showing up in the PHP server logs. Any ideas as to why this would be happening?

<form method="post"> 
 <div class="hiddenFields">
  <input type="hidden" name="XID" value="{XID_HASH}"> 
  <input type="hidden" name="ACT" value="13">
  <input type="hidden" name="RET" value="/account/register/success"> 
  <input type="hidden" name="FROM" value=""> 
  <input type="hidden" name="site_id" value="1"> 
 </div>
 <fieldset>
  <label for="m_field_id_1">First Name</label>
  <input type="text" name="m_field_id_1" id="m_field_id_1" value="">

  <label for="m_field_id_2">Last Name</label>
  <input type="text" name="m_field_id_2" id="m_field_id_2" value="">

  <label for="username">Email</label>
  <input type="text" name="email" id="email" value="">

  <label for="username">Username</label>
  <input type="text" name="username" id="username" value="">

  <label for="m_field_id_7">Phone Number</label>
  <input type="text" name="m_field_id_7" id="m_field_id_7" value="">

  <label for="password">Password</label>
  <input type="password" name="password" id="password" value="">

  <label for="password_confirm">Re-Enter Password</label>
  <input type="password" name="password_confirm" id="password_confirm" value="">

  <label for="m_field_id_3">Address</label>
  <input type="text" name="m_field_id_3" id="m_field_id_3" value="">

  <label for="m_field_id_4">City</label>
  <input type="text" name="m_field_id_4" id="m_field_id_4" value="">

  <label for="m_field_id_5">State</label>
  <input type="text" name="m_field_id_5" id="m_field_id_5" value="">

  <label for="m_field_id_8">Zip</label>
  <input type="text" name="m_field_id_8" id="m_field_id_8" value="">

  <input type="submit" value="Register">
 </fieldset>
</form> 

Order member list by entries in weblog X

2012-11-15T11:20:17-05:00

This question may be related to a resolved thread.

Hi All

I’m trying to create a list of members, ordered by who’s posted most entries in my News weblog. If they haven’t posted in that weblog, they shouldn’t appear in the list. So far I’ve got to this:

{exp:query sql="SELECT screen_name, total_entries FROM exp_members ORDER BY total_entries DESC"}
 {if "{total_entries}" != "0"}
  {screen_name} [{total_entries}]
 {/if}
{/exp:query} 

... which works, but it looks for total_entries in ALL weblogs. Any idea how I can order this by total_entries in just my News weblog?

Thanks, Frank

want to upgrade to current version from 1.6.4 ... what steps do i need to take?

2012-11-18T22:49:24-05:00

hey there—

i want to upgrade my version of EE from 1.6.4 to the most current version. i realize this is a very outdated release. what do i need to do to make the upgrade?

let me know, when there’s a moment.

thanks and cheers—

safecraker issue

2012-11-18T16:37:02-05:00

I set a simple safecraker input form:

{exp:safecracker channel=‘blog’ return=‘reserved/segnalazioni’ include_jquery=‘no’}
Azienda inadempiente <input type=“text” id=“title” name=“title” value=”{title}” maxlength=“75” size=“75"rows=“10” cols=“30”></p>
Luogo, circostanza, data della segnalazione {field:testo}
Descrizione dettagliata dell’inadempienza da segnalare:{field:descrizione}
<input type=“submit” value=“Submit” />

But I wasn’t able to write in:

“The URI you submitted has disallowed characters.”

Any suggest?

MySql ERROR

2012-11-20T12:37:20-05:00

Im getting this message when we try to publish a content… Help please. Thanks!

MySQL ERROR:

Error Number: 1364

Description: Field 'sent_trackbacks' doesn't have a default value

Query: INSERT INTO `exp_weblog_titles` (`entry_id`, `weblog_id`, `author_id`, `site_id`, `ip_address`, `title`, `url_title`, `entry_date`, `edit_date`, `versioning_enabled`, `year`, `month`, `day`, `expiration_date`, `comment_expiration_date`, `sticky`, `status`, `allow_comments`, `allow_trackbacks`, `forum_topic_id`, `dst_enabled`) VALUES ('', '50', '9', '1', '173.50.95.66', 'test', 'test', '1353447240', '20121120113426', 'y', '2012', '11', '20', '0', '0', 'n', 'open', 'y', 'y', '0', 'n')

white screen on admin

2012-09-07T12:25:27-05:00

Hello,

The front end of my 1.6.8 site was working fine but we noticed a couple weeks ago that the admin backend gave us a white screen after we logged in at the admin login screen. We tried to enable error reporting the config file without luck.

Today I tried to upgrade to 1.7.3. The update wizard worked through all versions until going from 1.7.2 to 1.7.3, when this error happened:

Error: The following error was encountered
MySQL ERROR:

Error Number: 1054

Description: Unknown column 'ip_address' in 'exp_mailing_list'

Query: ALTER TABLE `exp_mailing_list` CHANGE `ip_address` `ip_address` VARCHAR(45) NOT NULL 

What should we do to get this all fixed?

UPDATE: I ran this sql query and the update worked so we are on 1.7.3 now:


alter table exp_mailing_list add ip_address varchar(45) not null

That didn’t fix the white screen problem. It also introduced a second problem with my templates.

1. After logging in at the admin screen, the screen is blank and the url is something like:

my_url/system/index.php?S=dc6b8f263c6e5be705870cc793cdd80dfaca605f

2. My front end now says things like:

ERROR The following tag has a syntax error: {exp:user:edit}. Please correct the syntax in your template.